Forum Discussion

packie's avatar
packie
Brass Contributor
Jun 16, 2024

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

Resources