ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to make a formula to increase sales of january by 1.56% need (https://www.excelbanter.com/new-users-excel/115939-how-make-formula-increase-sales-january-1-56%25-need.html)

Marquin

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


Max

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%




All times are GMT +1. The time now is 06:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com