"superkopite" wrote:
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).