adding 5% and round off the result

[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

 

[Frank Kabel]

Hi
try
=ROUND(C1*1.05,2)

 

[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

 

[Frank Kabel]

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

 

[aboiy]

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

 

[Frank Kabel]

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(D13)

 

[JE McGimpsey]

One way:

=CEILING(A2*1.05,10)

 

[aboiy]

JE & Frank,

Thank you so much, it reduce my workloads.

Regards,

aboiy