Excel Formula

[Bernie]

I'm dealing with only 4 specific columuns in a worksheet. If the cell in one
column is YES (O4) and the two other columns have dates greater than 5 Jul
08, then I want to show "GO" in the fourth column otherwise it would reflect
"NO GO". I should know this but haven't worked with Excel for about a year
and forgotten too much.

Appreciate any assistance.

 

[Don Guillett]

A formula solution where your date to compare is in cell o1

=IF(AND(O2="yes",P2>$O$1,Q2>$O$1),"go","no go")

 

[Harlan Grove]

I'm dealing with only 4 specific columuns in a worksheet. If the cell in one
column is YES (O4) and the two other columns have dates greater than 5 Jul
08, then I want to show "GO" in the fourth column otherwise it would reflect
"NO GO".  I should know this but haven't worked with Excel for about a year
and forgotten too much.

If the Yes/No(/Other?) were in A3, the two dates in B3 and C3, and the
result in D3, then use the following formula in cell D3.

=IF(AND(A3="Yes",MIN(B3,D3)>DATE(2008,7,5)),"GO","NO GO")

 

[Michael]

Try this:
=IF(AND(O4="Yes",P4>7/5/2008,Q4>7/5/2008),"GO","NO GO")

 

[Harlan Grove]

Try this:
=IF(AND(O4="Yes",P4>7/5/2008,Q4>7/5/2008),"GO","NO GO")

....

Doesn't do what the OP asked. Excel will *ALWAYS* evaluate 7/5/2008 as
7 divided by 5 divided by 2008, or 0.000697211, which is less than all
valid dates after 31 Dec 1899 (1900 date) or 1 Jan 1904 (1904 date
system).

 

[Bernie]

Michael,

Here's what I typed in replacing p and q with the actual cell and it will
not give me a "GO" with dates after 5 Jul 08 in both cells.

=IF(AND(O4="Yes",ES7>7/5/2008,EU7>7/5/2008),"GO","NO GO")

 

[Bernie]

showed "NO GO" for valid dates greater than 5 jul 08 in those two cells.

 

[Bernie]

Guys,

Thanks for your help. All your suggestions worked.

 

[John C]

You might wanna add a little error trapping to this formula:
=IF(AND(A3="yes",(B3<>"")*(D3<>"")*MIN(B3,D3)>DATE(2008,7,5)),"GO","NO GO")

Currently will fail if one of the date cells has a valid date and the other
cell is blank.

 

[Bernie]

Thanks John, that's a good idea for another area of the spreadsheet. I do
have a question for you. All the data in the worksheet has to be greater
than 5 Jul 08 to be valid and I have several sections with various columns.
If I had a section with 4 columns (1 showing % complete and the other 3 are
data columns) and only two have valid dates, how would I type that formula in
the percentage column? This is how much of the spreadsheet is structured.

 

[Harlan Grove]

If the Yes/No(/Other?) were in A3, the two dates in B3 and C3, and the
result in D3, then use the following formula in cell D3.

=IF(AND(A3="Yes",MIN(B3,D3)>DATE(2008,7,5)),"GO","NO GO")

Sorry, typo, should be

=IF(AND(A3="Yes",MIN(B3,C3)>DATE(2008,7,5)),"GO","NO GO")

If you also want to trap blank cells, change this to

=IF(AND(A3="Yes",MIN(N(B3),N(C3))>DATE(2008,7,5)),"GO","NO GO")