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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula issue with the "OR" command
If you're struggling with debugging, it's usually best to break your formula
into manageable chunks. What value does the formula =MIN(FA10,FD10,GA10,GB10,GC10,GD10) return? -- David Biddulph "Bernie" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula issue with the "OR" command
if each has a date greater than 1 may 09, then "GO" will show in the cell, if
any do not have a date or a date greater than 1 may 09, the cell will show "NO GO". the problem with the one cell equaling 3 is that cells EZ or GD can be accepted with cells GA, GB, and GC. "David Biddulph" wrote: If you're struggling with debugging, it's usually best to break your formula into manageable chunks. What value does the formula =MIN(FA10,FD10,GA10,GB10,GC10,GD10) return? -- David Biddulph "Bernie" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula issue with the "OR" command
You didn't answer the question, Bernie.
To answer your question, no, you don't have too many arguments. Excel can handle that many conditions. As you've found out, it's usually humans that can't. In addition to David's question, in the condition where you're checking f10=3, why do you have separate Min functions? Why not combine them? If they need to be separated, what's in EZ10 vs GD10? My bet is you have a parenthesis out of place. Regards, Fred. "Bernie" wrote in message ... if each has a date greater than 1 may 09, then "GO" will show in the cell, if any do not have a date or a date greater than 1 may 09, the cell will show "NO GO". the problem with the one cell equaling 3 is that cells EZ or GD can be accepted with cells GA, GB, and GC. "David Biddulph" wrote: If you're struggling with debugging, it's usually best to break your formula into manageable chunks. What value does the formula =MIN(FA10,FD10,GA10,GB10,GC10,GD10) return? -- David Biddulph "Bernie" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula issue with the "OR" command
So you are saying that when the condition is met, you get a "GO" result
(despite the question that you asked), and that when the condition isn't met you get a "NO GO". Glad to hear that you've confirmed that the formula is working correctly. -- David Biddulph "Bernie" wrote in message ... if each has a date greater than 1 may 09, then "GO" will show in the cell, if any do not have a date or a date greater than 1 may 09, the cell will show "NO GO". the problem with the one cell equaling 3 is that cells EZ or GD can be accepted with cells GA, GB, and GC. "David Biddulph" wrote: If you're struggling with debugging, it's usually best to break your formula into manageable chunks. What value does the formula =MIN(FA10,FD10,GA10,GB10,GC10,GD10) return? -- David Biddulph "Bernie" wrote in message ... 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. |
Reply |
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 |