OR IF AND formula

[srizki]

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?

Please help

Thanks

Regards,

 

[Von Pookie]

Are you wanting something like this?

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

 

[srizki]

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.

 

[Von Pookie]

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.

 

[srizki]

Ok I got you,

Thanks

 

[srizki]

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

 

[Von Pookie]

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."

 

[Seti]

And to shorten the formula a little,

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

 

[srizki]

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


thanks again