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
Bookmarks