View Single Post
  #1   Report Post  
Sally J
 
Posts: n/a
Default 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