SOLVED

Return empty cell when cells are empty

Brass Contributor

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

1 Reply
best response confirmed by packie (Brass Contributor)
Solution

@packie 

Does this do what you want?

 

=IF(AND(L5="", B5<>""), TODAY()-B5, "")

1 best response

Accepted Solutions
best response confirmed by packie (Brass Contributor)
Solution

@packie 

Does this do what you want?

 

=IF(AND(L5="", B5<>""), TODAY()-B5, "")

View solution in original post