Min Value with Formula?

[DucDuc]

Hello Everyone,

You guys always blow me away with your solutions when I've needed them. Thank you!

I have a formula, =Round((AW2*.85)+IF(V2="yes",-700),-2) and it works perfectly but I would like to add a min value of 4000. I have tried =MIN(4000,.....my formula, but not been able to get the result. Will this be possible without moving to a new column/inclusive to existing formula?

Thanks in advance for having a look and offering suggestions

Best,
Tom

 

[Joe4]

Do you mean that you want the value to come back to be at least 4000?
If so, you need to use MAX, not MIN, i.e.

=MAX(ROUND((AW2*0.85)+IF(V2="yes",-700),-2),4000)

Think about it, if you say I want the minimum of 100 and 4000, the answer is 100.
But if you say that you want the maximum of 100 and 4000, the answer is 4000.

 

[DucDuc]

Brilliant! Thank you! Makes sense, I learned something today and it's only 8:48AM, thank you.

 

[Joe4]

You are welcome.