Could someone advise me what I'm doing wrong?
I'm having a value error appear on this formula.
=OR(AND(ISNUMBER($G9),$H9="N"),(AND(ISNUMBER($I9), ISNUMBER
($G9),$H9="Y")),"Open","Closed")
I'm trying to get a cell to show 'open' and 'closed' based
on:
"Open" displayed when G9 has a date and H9=Y
"Closed" displayed when G9 has a date and H9=N
"Closed" displayed when G9 has a date and H9=Y and I9 has
a date.

TIA