If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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(Q89TODAY(),P89+730)) ). In the Status. =IF(P89="","",IF(P89="N/A","N/A",IF(R89TODAY(),"Valid",IF(R89TODAY(),"Expired" )))) Why the result is (Fals)? |
#2
|
|||
|
|||
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(R89TODAY(),"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(Q89TODAY(),P89+730)) ). In the Status. =IF(P89="","",IF(P89="N/A","N/A",IF(R89TODAY(),"Valid",IF(R89TODAY(),"Expired" )))) Why the result is (Fals)? |
Thread Tools | |
Display Modes | |
|
|