Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
For Shane Devenshire
Shane, ran the following formula and for F9=3 and it worked for the first
part; however, I entered data to ensure the second part of the formula when F9=3 works and it gave me "NO GO" when it should've been "GO". =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"))) Did enter something wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
For Shane Devenshire
I'm not Shane, but see your later thread.
It is normally better to keep your discussion in the same thread so that people can see the previous discussion, rather than starting new threads. -- David Biddulph "Bernie" wrote in message ... Shane, ran the following formula and for F9=3 and it worked for the first part; however, I entered data to ensure the second part of the formula when F9=3 works and it gave me "NO GO" when it should've been "GO". =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"))) Did enter something wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shane please | New Users to Excel |