IF function isnt working

[markdwalls]

Hi All,

I'm currently trying to get an IF function to work where i want the function to basically say, if the number is below -10000 or above 10000 then display "STRAIGHT" in the cell. If not then display the original cell value. I've tried =IF((BO31<'-10000,BO31>10000),"STRAIGHT",BO31) but it doesnt seem to work and i cant figure out a solution. Please can anyone give me some guidance.

Thanks in advance,

Mark

 

[hrayani]

Hello,

Try This

=IF(OR(BO31<-10000,BO31>10000),"STRAIGHT",BO31)

 

[Fluff]

How about
=IF(ABS(BO31)<=10000,BO31,"Straight")