Thread
:
Formula given three answer choices
View Single Post
#
3
Sally J
Posts: n/a
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
Reply With Quote