Formula help!
 

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

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" wrote in message
...
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

Thank you! Much appreciated!

-----Original Message-----
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" wrote in
message
...
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


.