Help with IF formula

[OillyBob55]

Hi All

I need to put an "=" in a cell if the value in a B26 is less than -1 or greater than +1
I need to put an "=" in a cell if the value in B26 is between -1 and 1

I have the following formula but cant get them to work correctly. ( iam sure its something simple i have done)

=IF(OR(B26<"$H$26",B26>"$H$27"),"","=") this is for between

=IF(B26>$H$27,IF(B26>$H$26,"",""),"=") This is for <> than

Thanks
Rob

[Phuocam]

Try:

=IF(OR(B26<$H$26,B26>$H$27),"","=")

[OillyBob55]

Worked a charm thanks you .

[Pete_UK]

You could also do this:

=IF(ABS(B26)<=1,"=","")

Hope this helps.

Pete