Formula help!

[Onion]

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

 

[Tim C]

Try:

=IF(OR(AND(ISNUMBER($G9),$H9="N"),AND(ISNUMBER($I9),ISNUMBER($G9))),"Closed","Open")

or

=IF(AND(ISNUMBER($G9),OR($H9="N",ISNUMBER($I9))),"Closed","Open")

Tim C

 

[Onion]

Thank you! Much appreciated!

-----Original Message-----
Try:

=IF(OR(AND(ISNUMBER($G9),$H9="N"),AND(ISNUMBER ($I9),ISNUMBER($G9))),"Closed","Open")
($I9))),"Closed","Open")

Tim C




.