| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I complete this nested if formula
This formula is working for the condition "If Long" but how do I add "If
Short" in a nested formula thats checks both criteria? =IF(AND(B3="Long",H3<E3-G3),"NO GOOD","GOOD") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I complete this nested if formula
Depends on how you want it nested, but my guess is:
=IF(AND(OR(B3="Long",B3="Short"),H3<E3-G3),"NO GOOD","GOOD") If B3 equals "Long" or "Short, and H3<E3-G3, then cell displays "no good". If either condition is false, returns "good". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bobbybee" wrote: This formula is working for the condition "If Long" but how do I add "If Short" in a nested formula thats checks both criteria? =IF(AND(B3="Long",H3<E3-G3),"NO GOOD","GOOD") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SET UP A FORMULA TO SUBTRACT AFTER EACH ROW I COMPLETE | Excel Worksheet Functions | |||
| Reference Cells from other Workbook to complete Formula | Excel Discussion (Misc queries) | |||
| Amount in Words Complete Right Formula | New Users to Excel | |||
| Automation Formula almost complete | Excel Discussion (Misc queries) | |||
| How do I create a conditional formula that hides a complete row o. | Excel Worksheet Functions | |||
Linear Mode
