| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement on multiple levels
Hi Lynette,
Am Mon, 3 Mar 2014 17:43:48 +0000 schrieb ljochmann: If any of the statements are FALSE then do (BH5-AT5)*BF5. Does not need to be a combination of one or the other, just is any are false then I would like the formuala to happen. then try: =IF(OR(E5={106547;112565;133256},COUNT(SEARCH({"VE N-NUM";"STARTUP";"ES";"TPG"},H5)),BF5<1),0,(BH5-AT5)*BF5) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple levels of sumif? | Excel Worksheet Functions | |||
| If, Then formula - Multiple levels | Excel Worksheet Functions | |||
| How many levels of an IF statement is allowed within a Nested IF? | Excel Programming | |||
| How do I create an "IF" statement with more than 7 levels? | Excel Worksheet Functions | |||
| Creating multiple folder levels | Excel Programming | |||
Threaded Mode
