Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm using the following formula if F8 =1 or 2:
=IF(AND(F8=1,MIN(EW8,FA8,FD8)DATE(2009,5,1)),"GO" ,IF(AND(F8=2,MIN(EW8,FA8,FC8,FD8)DATE(2009,5,1)), "GO","NO GO")) If F8 = 3, I want to use an "or" to shorten the formula below and add it to formula above but I can't it out. =IF(AND(F9=3,MIN(EZ9,FA9,FD9,GA9,GB9,GC9)DATE(200 9,5,1)),"GO",IF(AND(F9=3,MIN(FA9,FD9,GA9,GB9,GC9,G D9)DATE(2009,5,1)),"GO","NO GO")) Can't quite figure it out because of all the parenthesis' Appreciate any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another formula problem | Excel Worksheet Functions | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
What is the problem with this formula? | Excel Worksheet Functions | |||
I have a problem with my Formula. | Excel Worksheet Functions |