Formula given three answer choices

[Guest]

I need to create a formula that will return the correct number

Here is an example of what I am looking for:
if X>0 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

 

[N Harkawat]

=(A1>0)*MIN(53,A1)

 

[Guest]

Thanks that worked great!

=(A1>0)*MIN(53,A1)

 

[Guest]

Sally,

I'm confused as to what you want to do:

if X>0 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 X>0 at any time. It could be between 0 and 53 and the answer
would still be 0.
Did I miss something?