Fals Result in IF Formula
 

Hello,

Thank you all of helping us in Genral, you haelped me so many times.

Start End Exp. Date Status
11/15/09 11/15/09 11/15/11 Valid
04/05/08 04/05/08 04/05/10 FALSE
01/05/08 01/05/08 01/04/10 Expired

N/A N/A N/A N/A

Inn the Exp. Date.
=IF(P89="N/A","N/A",IF(Q89TODAY(),P89+730,IF(Q89<TODAY(),P89+730)) ).

In the Status.
=IF(P89="","",IF(P89="N/A","N/A",IF(R89TODAY(),"Valid",IF(R89<TODAY(),"Expired" ))))

Why the result is (Fals)?

Fals Result in IF Formula
 

Hi,

Your formula checks if the cell is < or today. In the case of G90 it is
neither because it returns todays date so it is = to today. You will have to
alter one of your conditions to capture todays date along the lines of

=IF(P89="","",IF(P89="N/A","N/A",IF(R89=TODAY(),"Valid",IF(R89<TODAY(),"Expired "))))

Note the difference
......IF(R89=TODAY().....


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Khalid A. Al-Otaibi" wrote:

Hello,

Thank you all of helping us in Genral, you haelped me so many times.

Start End Exp. Date Status
11/15/09 11/15/09 11/15/11 Valid
04/05/08 04/05/08 04/05/10 FALSE
01/05/08 01/05/08 01/04/10 Expired

N/A N/A N/A N/A

Inn the Exp. Date.
=IF(P89="N/A","N/A",IF(Q89TODAY(),P89+730,IF(Q89<TODAY(),P89+730)) ).

In the Status.
=IF(P89="","",IF(P89="N/A","N/A",IF(R89TODAY(),"Valid",IF(R89<TODAY(),"Expired" ))))

Why the result is (Fals)?