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

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.

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

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

--
Regards

Roger Govier


"junk dog" wrote in message
...
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.

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

thanks, roger!

"Roger Govier" wrote:

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

--
Regards

Roger Govier


"junk dog" wrote in message
...
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.