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


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=513925