View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to make a formula to increase sales of january by 1.56% need

Assuming Jan figs running in B2 down

Enter into C1: 1.56% (input the "%" as well)

Then put in C2: =B2*(1+$C$1)
Copy C2 down as far as required
Col C will return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Marquin" wrote in message
...

how to make a formula to increase sales of january by 1.56%