G Guest May 30, 2007 #1 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??????
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??????
G Guest May 30, 2007 #2 =IF(F4="Y",MAX(MIN(RATE*O4,275),150),if(f4="n",max(Rate*o4,150),"Neither Y nor N"))
