Member Avatar for Jemuel

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 because: Moved.
  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by ddanbe
Member Avatar for ddanbe

Try AND instead of OR

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.