Forum Discussion
Solved
IF condition on DATEDIF value
Dear Friends, Please help me out for the below issue. I have a DATEDIF value, and on which the IF condition is not working. But if I change the DATEDIF value to numeric mannually then the IF functio...
Riyaz,
I would solve it this way.
=LOOKUP(DATEDIF(D3,TODAY(),"M"),$H$1:$H$5,$I$1:$I$5)
Hi Riyaz,
You compare text value which is returned by first formula with some numbers. In logical operations any text is aways "bigger" than any numbers, e.g =("0" > 1) returns TRUE.
You need to change your logic, use numbers for the age or make conversion in second one.
Thank you Sergei....
