Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a formula for the the following calculation (a to d)?
I have tried the following way but not successful. =if(a20.01,"1","0",if(a2100.01,"2","0",if(a2200 .01,"3","0".....continued to d) a) If the amount is greater than 0.01, than the rate is $1.00 b) If the amount is greater than 100.01, than the rate is $2.00 c) If the amount is greater than 200.01, than the rate is $3.00 d) If the amount is greater than 300.01, than the rate is $4.50 e) If the amount is greater than 400.01, than the rate is $5.50 Thank you very much for your response. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Calculation | Excel Worksheet Functions | |||
Calculation vs formula | Excel Worksheet Functions | |||
calculation in an if formula | Excel Worksheet Functions | |||
base formula calculation on whether different cell has formula | Excel Programming | |||
base formula calculation on whether different cell has formula | Excel Programming |