Kristen_cancerkiller
Member
I currently have the following formula in excel: =IF((V14="N"),"T", IF(AN14>TIME(3,0,0),"T","F")) But, I need to add one more requirement to the formula to return "T" in the second 'if' function. What I need is =if(and(aa30<time(12,0,0), an14>time(3,0,0),"T","F".
However, when I create that formula as shown here: =IF((V14="N"),"T", IF(and(aa14<time(12,0,0),AN14>TIME(3,0,0),"T","F"))) - it's telling me that there is a problem with my formula. Can anyone tell me what I'm missing? I'm just not seeing it.
However, when I create that formula as shown here: =IF((V14="N"),"T", IF(and(aa14<time(12,0,0),AN14>TIME(3,0,0),"T","F"))) - it's telling me that there is a problem with my formula. Can anyone tell me what I'm missing? I'm just not seeing it.