How do I complete this formula???

Actually, if F4 ="N" the result should be the greater of (rate*O4) or 150

"Peo Sjoblom" wrote:

What do you want the formula to return if F4 is not "Y"?

=IF(F4="Y",MAX(MIN(RATE*O4,275),150),"No")