Coomplete the formula

M

marwildfw

Actually, if F4 ="N" the result should be the greater of (rate*O4) or 150
How would I add the above to the formula below??????
 
D

Duke Carey

=IF(F4="Y",MAX(MIN(RATE*O4,275),150),if(f4="n",max(Rate*o4,150),"Neither Y
nor N"))
 
Top