need help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula not working for me now 2
OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP! 5
EXCEL FORMULA , MEET 2 CRITERIA THEN SUM 6
Formula changes on own accord 7
Excel auto calculation formula question. 7
Network days question 2
Excluding Negative Numbers 9
sum formula that includes zero? 3

Back
Top