| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I complete this nested if formula | Excel Worksheet Functions | |||
| HOW DO I SET UP A FORMULA TO SUBTRACT AFTER EACH ROW I COMPLETE | Excel Worksheet Functions | |||
| Amount in Words Complete Right Formula | New Users to Excel | |||
| Automation Formula almost complete | Excel Discussion (Misc queries) | |||
| Filling down formula to cover complete range | Excel Programming | |||
Hybrid Mode
