# OR IF AND formula

#### srizki

##### Well-known Member
OR IF AND
I am looking for a formula that looks into a cell and see if the cell value is over \$100,000 or under \$-100,000, it leaves it blank “”, otherwise it puts “below Scope”.
My formula =OR(IF(A25,”<-100000”,”>100000”,””,”BELOW SCOPE”)
=IF(Q12,"<-100000"),OR(Q8,"<-100000"),"","BELOWSCOPE")
=OR(IF(Q7<-100000),IF(Q7>100000)"","BELOW SCOPE"))
All fail to work.
And many other different variations of this formula are not working. What am I doing wrong?

Thanks

Regards,

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Are you wanting something like this?

=IF(OR(A1>100000,A1<-100000),"","BELOW SCOPE")

Yes thats exactly what I want, I don't know how I could not do it mysef
Should IF always be before OR ?

Thanks Von, you've helped me many times.

Thank you very much.

srizki said:
Should IF always be before OR ?

For the most part, that's how I usually see it--but it would also depend on what you're trying to do with the formula.

Ok I got you,

Thanks

To make it more complicated, what if the look up cell is blank or has zero value, the formula still says Below Scope, I want it to say nothing because it is not below scope but it is nothing so it should leave it blank.

Thanks

You can add it to the OR statement:

=IF(OR(A1="",A1=0,A1>100000,A1<-100000),"","BELOW SCOPE")

So what this says:

If A1 is any of the following:
- blank
- 0
- greater than 100000
- less than -100000

display a blank cell.

If the value in A1 does not match any of those conditions, display "BELOW SCOPE."

And to shorten the formula a little,

=IF(OR(A1="",A1=0,ABS(A1)>100000),"","BELOW SCOPE")

Thank you very much to both of you, I shortened the formula as per Seti

thanks again

Replies
2
Views
98
Replies
5
Views
303
Replies
0
Views
331
Replies
3
Views
3K
Replies
4
Views
356

1,206,970
Messages
6,075,921
Members
446,170
Latest member
zzzz02

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back