Return empty cell when cells are empty
Hi,
=IF(ISBLANK(L5),TODAY()-B5,””)
when L5 and B5 are both empty the above formula is returning the value 45459 when it should be returning an empty cell.
what is going on here and how do I fix it?
Thankyou for taking a look
Hi,=IF(ISBLANK(L5),TODAY()-B5,””) when L5 and B5 are both empty the above formula is returning the value 45459 when it should be returning an empty cell. what is going on here and how do I fix it? Thankyou for taking a look Read More
