adding 5% and round off the result

  • Thread starter Thread starter aboiy
  • Start date Start date
A

aboiy

Hi,

Is it possible to make a formula wherein the basic salary
of the employee will automatically increase to 5% upon
reaching his contract expiration, but if the amount should
be roundoff.

Ex. A B C D
Name Date Hired Basic Salary New Rate
George Cloone 15.Sep.00 5,700 5,985
Saman Martinez 23.Aug.02 4,300 4,515

Where column "D" results should be round off to:

New Rate
5,985 should be 5,990
4,515 should be 4,520

For your kind assistance.

Thanks in advance

aboiy
 
Hi Frank,

Once again thanks for the tip, referring to my question is
it possible also that the result will add up to 10's to
the resulting figure.

5,985 should be 5,990
4,515 should be 4,520

My second question is about the formula for the date, is
there a way to calculate the contract date base on the
present date, =today(). Let say if someone contract is
expiring 5 days from now can it calculate salary by adding
5% from its basic salary.

Thanks in advance.

aboiy
 
Hi
not sure about your first question about adding up to '10' but for your
second question use something like
=IF(B1<=TODAY()+5,ROUND(C1*1.05,2),C1)

with B1 your contract date
 
Hi Frank,

the date formula works great.

about my first question i dont know how to call it but
there should not be any fraction when the 5% is added to
the basic salary.

Basic +5% Result Correct
7,500 375 7,875 7,880
5,545 277 5,822 5,830
8,750 438 9,188 9,190
4,575 229 4,804 4,810

From the above example, the "result" col.has a fraction of
5,2,8,4 at the end of the figure, it should be added so
that the end figure will be "0".

Hope you understand what i mean.

Regards,

aboiy
 
Hi
in the first cells of column d use the round function. In the last cell
in col. D you may use something like
=10-SUM(D1:D3)
 
Back
Top