software

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=quot;OFFquot;,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 quot;OFFquot; or empty

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

Could someone please tell me what i have done wrong.

Cheers

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=513925quot;superkopitequot; wrote:
gt; what i need to do is the add an or statement that will
gt; return a value of 0 if B3 is either quot;OFFquot; or empty
gt; This is my attempt at the code;
gt; =IF(OR(B3=quot;OFFquot;,quot; quot;),0,1)

=IF(OR(B3=quot;OFFquot;,B3=quot;quot;), 0, 1)

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

Hi!

Try this:

=IF(OR(B3={quot;offquot;,quot;quot;}),0,1)

Biff

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; Hiya guys and gals
gt;
gt; I can't believe i cannot work this out i am having a real stupid moment
gt; (mind you it is 3:30am!)
gt;
gt; The code that i have is;
gt;
gt; =IF(B3=quot;OFFquot;,0,1)
gt;
gt; and what i need to do is the add an or statement that will return a
gt; value of 0 if B3 is either quot;OFFquot; or empty
gt;
gt; This is my attempt at the code;
gt; =IF(OR(B3=quot;OFFquot;,quot; quot;),0,1)
gt;
gt; Could someone please tell me what i have done wrong.
gt;
gt; Cheers
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=513925
gt;

Thanks Biff

That is perfect!--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=513925