| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula problem
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula problem
Bernie,
=IF(AND(OR(F8=1,F8=2),MIN(EW8,FA8,FD8)DATE(2009,5 ,1)),"GO","NO GO") HTH, Bernie MS Excel MVP "Bernie" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula problem
Ooops, forgot the second formula
=IF(AND(OR(F9=3,F9=1,F9=2),MIN(EZ9,FA9,FD9,GA9,GB9 ,GC9)DATE(2009,5,1)),"GO","NO GO")) Or, it you have a lot of integer values, something like: =IF(AND(AND(F9=1,F9<=5),MIN(EZ9,FA9,FD9,GA9,GB9,G C9)DATE(2009,5,1)),"GO","NO GO")) HTH, Bernie MS Excel MVP "Bernie" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula problem
Hi Bernie Deitrick,
Using OR in that way may not work since each AND statement is looking at different cells in the MIN part. Cheers, Shane Devenshire "Bernie Deitrick" wrote: Ooops, forgot the second formula =IF(AND(OR(F9=3,F9=1,F9=2),MIN(EZ9,FA9,FD9,GA9,GB9 ,GC9)DATE(2009,5,1)),"GO","NO GO")) Or, it you have a lot of integer values, something like: =IF(AND(AND(F9=1,F9<=5),MIN(EZ9,FA9,FD9,GA9,GB9,G C9)DATE(2009,5,1)),"GO","NO GO")) HTH, Bernie MS Excel MVP "Bernie" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula problem
Hi,
=IF(AND(F9=3,OR(MIN(EZ9,FA9,FD9,GA9,GB9,GC9)DATE( 2009,5,1),MIN(FA9,FD9,GA9,GB9,GC9,GD9)DATE(2009,5 ,1))),"GO","NO GO") Howerver, you could also shorten these formula by Putting the date into a cell and referencing it, for example, in your first formula: =IF(AND(F8=1,MIN(D1,D3,D5)A1),,IF(AND(F8=2,MIN(D1 ,D3,D7,D5)A1),,"No "))&"Go" Where A1 contains the date. If this helps, please click the Yes button Cheers, Shane Devenshire "Bernie" wrote: 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula problem
Thanks Shane. I added what you had to the other part and it worked.
Unfortunately the dates aren't static but I can see the logic to it. In this worksheet eveything revolves what cell F's value is. Appreciate your help. "Shane Devenshire" wrote: Hi, =IF(AND(F9=3,OR(MIN(EZ9,FA9,FD9,GA9,GB9,GC9)DATE( 2009,5,1),MIN(FA9,FD9,GA9,GB9,GC9,GD9)DATE(2009,5 ,1))),"GO","NO GO") Howerver, you could also shorten these formula by Putting the date into a cell and referencing it, for example, in your first formula: =IF(AND(F8=1,MIN(D1,D3,D5)A1),,IF(AND(F8=2,MIN(D1 ,D3,D7,D5)A1),,"No "))&"Go" Where A1 contains the date. If this helps, please click the Yes button Cheers, Shane Devenshire "Bernie" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
