| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula issue with the "OR" command
Using the formula below. The problem is when F10=3. The first part works
and I get a "GO" when the requirements are met; however, when the requirements are met for the second part it still gives "NO GO". I'm not sure where my error is on this. Is there too many arguements in this formula? =IF(AND(F10=1,MIN(EW10,FA10,FD10)DATE(2009,5,1)), "GO",IF(AND(F10=2,MIN(EW10,FA10,FC10,FD10)DATE(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO GO"))) Appreciate any assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Need command line to change "#DIV/0!" into a "0" (zero) | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
Threaded Mode
