G Guest May 30, 2007 #1 How do I complete this formula??? Actually, if F4 ="N" the result should be the greater of (rate*O4) or 150
How do I complete this formula??? Actually, if F4 ="N" the result should be the greater of (rate*O4) or 150
W WhytheQ May 30, 2007 #2 =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)
=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)
