Linea increase
I have been using IF statements but specific values are not accurate enough.
I want to increase my initial value gradually. I.E between 50 - 100 increase values by 5 to evenutally 0 so 50 would become 55 and 100 would stay 100. I require a linea increase to improve accuracy. |
Linea increase
If you write e.i. 100 in A1, then remember to use the "$"-sign around A and 1.
You might write a statement (with the increasement of 5 and so on) and then copy the formula down to begin with. Put $A$1 in an IF statement, and it wil always refer to that specific cell. Hope you can use it - sorry my explanition is poor! -- Therese "Breadwin" skrev: I have been using IF statements but specific values are not accurate enough. I want to increase my initial value gradually. I.E between 50 - 100 increase values by 5 to evenutally 0 so 50 would become 55 and 100 would stay 100. I require a linea increase to improve accuracy. |
All times are GMT +1. The time now is 03:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com