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%