Fals Result in IF Formula

[Khalid A. Al-Otaibi]

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(Q89>TODAY(),P89+730,IF(Q89<TODAY(),P89+730))).

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

Why the result is (Fals)?

 

[Mike H]

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.