IF and OR

[superkopite]

Hiya guys and gals

I can't believe i cannot work this out i am having a real stupid moment
(mind you it is 3:30am!)

The code that i have is;

=IF(B3="OFF",0,1)

and what i need to do is the add an or statement that will return a
value of 0 if B3 is either "OFF" or empty

This is my attempt at the code;
=IF(OR(B3="OFF"," "),0,1)

Could someone please tell me what i have done wrong.

Cheers

James

 

[joeu2004]

what i need to do is the add an or statement that will
return a value of 0 if B3 is either "OFF" or empty
This is my attempt at the code;
=IF(OR(B3="OFF"," "),0,1)

=IF(OR(B3="OFF",B3=""), 0, 1)

Note: No space between "". Or replace B3="" with
ISBLANK(B3).

 

[Biff]

Hi!

Try this:

=IF(OR(B3={"off",""}),0,1)

Biff

"superkopite" <[email protected]>
wrote in message
news:[email protected]...

 

[superkopite]

Thanks Biff

That is perfect!