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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
thanks, roger!

Roger Govier said:
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
Click to expand...
 
Back
Top