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