Simple IF statement

[Bob]

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

 

[T. Valko]

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

Try it like this...

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

Or...

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

 

[Bob]

Try it like this...

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

Or...

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

--
Biff
Microsoft Excel MVP









- 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

 

[T. Valko]

You're welcome. Thanks for the feedback!