Formula help to return TRUE or FALSE

Hi All,

I wish to create a formula to return a true or false answer:

If cell A10 = Sell
And the value in cell AC10 is between -1 and 1 but not equal to zero

So if the value in AC10 is 0.5 then the formula returns true but if the number is either less than -1, zero or greater than 1 then the formula returns false.

I have the following which doesn’t work:

=If(AC10=“sell”,OR(AC10>1,AC10<-1,AC10=0)

Any help would be great.

Thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are still new here, I have done it for you this time.)

Try

=IF(AND(A10="Sell",AC10>=-1,AC10<=1,AC10<>0),"TRUE","FALSE")

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.