Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I'll try to explain this
I have a value in Cell A either <25.01, <1000.01 or 1000.00 If the value in A returns true to <25.01 then Cell B value = A*.0325, if the value in A returns true to <1000.01 then Cell B Value=A*.02, and if the last value returns true then B=A*.01 How do I write this? |
#2
![]() |
|||
|
|||
![]()
meekone wrote...
I have a value in Cell A either <25.01, <1000.01 or 1000.00 If the value in A returns true to <25.01 then Cell B value = A*.0325, if the value in A returns true to <1000.01 then Cell B Value=A*.02, and if the last value returns true then B=A*.01 How do I write this? Your second and third tests are redundant. Replace the second test with <=1000. Once done, the third test will necessarily be true if the second is false. It's a mathematical necessity. So, try =A*IF(A<=25,0.0325,IF(A<=1000,0.02,0.01)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |