Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula given three answer choices
I need to create a formula that will return the correct number
Here is an example of what I am looking for: if X0 then the answer is 0 -- this is the min if X<53 then the answer is 53 -- this is the max amount if 0<X<53 then the anwer is X |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) |