How do I complete this Formula

M

marwildfw

How do I complete this formula???

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

WhytheQ

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
MS Project. Real progress of the project, % complete 1
Help, help! desparate for formula help!! 3
Coomplete the formula 1
Weighted % Complete calculation 1
formula for arriving net difference 0
Compute Additional Hours Needed Using "if" or "lookup" 1
Status and % complete of predecessor task 0

Top