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

=(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

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

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