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
|