|
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. |
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 05:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com