IF(AND(OR fx with positive and negative number range

Screenshot 2019-04-24 10.19.58.png

How do you write a proper IF(AND(OR fx in cells D2 thru D5 that states:
if the number in column B is >0, AND
the number in column c is >-150, <-109 OR >109, <150,
then cells D2 thru D5 populates a 1 if it does, and a "" if it doesn't?


Thanks in advance for any help!

Hi

first attempt...

=IF(B2<=0,"",IF(OR(AND(C2>-150,C2<-109),AND(C2>109,C2<150)),1,""))

Regards

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

I've tried this one =IF(AND(B2>0,AND(ABS(C2)<150,ABS(C2)>109)),1,"")
and this one (which is closer to what you wrote) =IF(OR(AND(B2>0,AND(C2>-150,C2<-109)),AND(B2>0,AND(C2>109,C2<150))),1,"")
and I get only one set that comes back as 1 for both.
What results do you expect?
AND possibly more important, is this supposed to be some kind of statement that covers B2 through C5 or is this done line by line (which the two I wrote would do) because your wording makes it sound like it needs to cover the whole range instead of line by line?

The thread title is exactly what I was describing and I've had two forum members help me achieve my answer rather quickly so I'm not sure what the problem is.

Read my instructions again:

Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

You have now changed it suitably - thanks. Please bear these guidelines in mind next time you create a thread. Think Google search terms when creating titles.

Try this:

=IF(AND(B2>0,B2<50,OR(AND(C2>-150,C2<-109),AND(C2>109,C2<150))),1,"")

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.