0

what did I've done wrong with this code?

=IF(OR(ISBLANK(C9),ISBLANK(B9)),"",IF(ISBLANK(C9),D9-TODAY(), "Reactivated"))

I want to make an event that if b9 and c9 is empty, the value would be empty. if only c9 is empty, then the output would be the remaining days left between the two dates, and if the two cell is not empty the output should be reactivated. The problem of this code was

IF(ISBLANK(C9),D9-TODAY()

not working. It returns the empty value. I appreciate for any answers. Thanks!

Edited by pritaeas: Moved.

2
Contributors
1
Reply
11
Views
3 Years
Discussion Span
Last Post by ddanbe
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.