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 |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Thanks that worked great!
"N Harkawat" wrote: =(A10)*MIN(53,A1) "Sally J" <Sally wrote in message ... 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 |
#4
|
|||
|
|||
Sally,
I'm confused as to what you want to do: 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 I'm going to assume that you check condition 1, and if it's met, you don't review conditions 2 or 3. Let's say that X0 at any time. It could be between 0 and 53 and the answer would still be 0. Did I miss something? "Sally J" wrote: 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 |
Reply |
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) |