Thread: Excel Formula
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Excel Formula

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.
--
** John C **

"Bernie" wrote:

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

"Harlan Grove" wrote:

Bernie wrote...
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")