how to show 3% increase in hourly pay in each cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

junk dog - 25 Apr 2007 10:16 GMT

want to be able to enter a hourly wage ie. $10.00 and when i enter $10.00 it
will automatically show the 3% increase added to the $10.00 showing $10.30.
thank you in advance.

Reply to this Message

Roger Govier - 25 Apr 2007 10:48 GMT

Hi

Without using an event macro in VBA, you cannot do it in the same cell.
You could put your percentage increase in a cell, for example in A1
enter 3%
in B2 enter
=A2*(1+$A$1)
Then as you enter 10.00 in A2, 10.30 will appear in cell B2

Signature

Regards

Roger Govier

> want to be able to enter a hourly wage ie. $10.00 and when i enter
> $10.00 it
> will automatically show the 3% increase added to the $10.00 showing
> $10.30.
> thank you in advance.

Reply to this Message

junk dog - 27 Apr 2007 02:52 GMT

thanks, roger!

> Hi
>
[quoted text clipped - 10 lines]
> > $10.30.
> > thank you in advance.

Reply to this Message