Simple IF statement

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
=if(E2 in ("CASH02", " "),"ACTIVE","CLOSED")

Try it like this...

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

Or...

=IF(OR(E2={"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









- Show quoted text -
Click to expand...

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
 
Back
Top