View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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.