How do I complete this Formula
 

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")

How do I complete this Formula
 

=IF(F4="N",MAX(150,(rate*O4)))
....where rate is a named range - in this case O3.

Hope this helps
J

(....would have been better using the WorksheetFunctions group)


On 30 May, 14:52, marwildfw
wrote:
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")- Hide quoted text -

- Show quoted text -