Inbetween formula help required

[Sue28]

Hi there. Can you please help me with a formula?

I want a cell to return the word "Write-Off" if a cell is between -$1 and $1. However the formula that I have doesn't work.

This is the formula I have created that doesn't work =IF(AND(B2>1, B2<-1), "WRITE OFF", "").

Thank you in advance.

[Tony Valko]

You just have the B2's reversed:

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

[bebo021999]

AND(B2>1,B2<-1) always return FALSE
i think it should be:
=IF(AND(B2>-1,B2<1)"WRITE OFF","")
Or
=IF(ABS(B2)<1,"WRITE OFF","")

[Sue28]

That worked! Thank you so much

[David A Coop]

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

[Tony Valko]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.