IF AND Statement Problem

[seanturner9005]

Morning Everyone

Could someone help me with an "if and" formula.

I want it to simple show "NO" if its out of the range I have set and "YES" if between.
Here is my formula I have at the moment

=IF(AND(C8>31104,C8<31604,"YES","NO"))

Doesn't seam to like this.

Regards

Sean

[zbor]

You have wrong closing brackets:

Please Login or Register  to view this content.

[Pete_UK]

You have a bracket in the wrong place - try it like this:

=IF(AND(C8>31104,C8<31604),"YES","NO")

Hope this helps.

Pete

[seanturner9005]

Many thanks Pete and zbor.