In simple terms i am trying to say if the value in box E2 is "CASH02"
or the cell is empty then put "ACTIVE" otherwise put "CLOSED"

I have tried many permutations of

=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

I would be grateful if somebody could please correct this. Thank you

=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

Try it like this...

=IF(OR(E2="CASH02",E2=""),"ACTIVE","CLOSED")

Or...

=IF(OR(E2={"CASH02",""}),"ACTIVE","CLOSED")

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
In simple terms i am trying to say if the value in box E2 is "CASH02"
or the cell is empty then put "ACTIVE" otherwise put "CLOSED"

I have tried many permutations of

=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

I would be grateful if somebody could please correct this. Thank you

On 30 Mar, 18:17, "T. Valko" wrote:
=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

Try it like this...

=IF(OR(E2="CASH02",E2=""),"ACTIVE","CLOSED")

Or...

=IF(OR(E2={"CASH02",""}),"ACTIVE","CLOSED")

--
Biff
Microsoft Excel MVP

"Bob" wrote in message

...



In simple terms i am trying to say if the value in box E2 is "CASH02"
or the cell is empty then put "ACTIVE" otherwise put "CLOSED"

I have tried many permutations of

=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

I would be grateful if somebody could please correct this. Thank you- Hide quoted text -

- Show quoted text -

Thank you, i could have been here all night.

If I understood you correctly - it might be:
=IF(OR(E2="CASH02",E2=""),"ACTIVE","CLOSED")
Micky


"Bob" wrote:

In simple terms i am trying to say if the value in box E2 is "CASH02"
or the cell is empty then put "ACTIVE" otherwise put "CLOSED"

I have tried many permutations of

=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

I would be grateful if somebody could please correct this. Thank you
.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
On 30 Mar, 18:17, "T. Valko" wrote:
=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

Try it like this...

=IF(OR(E2="CASH02",E2=""),"ACTIVE","CLOSED")

Or...

=IF(OR(E2={"CASH02",""}),"ACTIVE","CLOSED")

--
Biff
Microsoft Excel MVP

"Bob" wrote in message

...



In simple terms i am trying to say if the value in box E2 is "CASH02"
or the cell is empty then put "ACTIVE" otherwise put "CLOSED"

I have tried many permutations of

=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

I would be grateful if somebody could please correct this. Thank you-
Hide quoted text -

- Show quoted text -

Thank you, i could have been here all night.