G Guest Jan 22, 2004 #1 I'm using this formula: =IF(OR(L15=0<7),1,"FALSE") and I get the same "FALSE" answer when L15 is 4 and when it is 0. Could someone point out my error? Thanks
I'm using this formula: =IF(OR(L15=0<7),1,"FALSE") and I get the same "FALSE" answer when L15 is 4 and when it is 0. Could someone point out my error? Thanks
R Roger Govier Jan 22, 2004 #2 Hi Wayne Try =IF(OR(L15=0,L15<7),1,"FALSE") -- Regards Roger Govier Wayne Cameron said: I'm using this formula: =IF(OR(L15=0<7),1,"FALSE") and I get the same Click to expand... "FALSE" answer when L15 is 4 and when it is 0. Could someone point out my error? Thanks
Hi Wayne Try =IF(OR(L15=0,L15<7),1,"FALSE") -- Regards Roger Govier Wayne Cameron said: I'm using this formula: =IF(OR(L15=0<7),1,"FALSE") and I get the same Click to expand... "FALSE" answer when L15 is 4 and when it is 0. Could someone point out my error? Thanks