Inbetween formula help required

Originally Posted by Tony Valko

You just have the B2's reversed:

=IF(AND(B2>-1,B2<1),"WRITE OFF","")

You could also try =IF(ABS(B2)<=1,"Write Off","")

If you want the value 1 to be included, Tony's formula needs to be changed to =IF(AND(B2>=-1,B2<=1),"WRITE OFF","")

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".