=IF(AND(A12="9599",F12="Linkjoping"),"YES","NO")
I have used the above formula and in the specified cells they do contain these values - however, the result is always 'NO'?
=IF(AND(A12="9599",F12="Linkjoping"),"YES","NO")
I have used the above formula and in the specified cells they do contain these values - however, the result is always 'NO'?
Try
=IF(AND(A12=9599,F12="Linkjoping"),"YES","NO")
i.e, A12 is NOT text but formatted as GENERAL or NUMBER
Try
=IF(AND(A12=9599,F12="Linkjoping"),"YES","NO")
Thanks both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks