Thank you Max and Valko, learn something new every day.

"Max" wrote:

The problem is because any kind of text in col B (which contains mixed data -
text/numbers) will always evaluate as TRUE for numeric checks applied such
as: IF(B10

This revision using an additional: ISNUMBER(B1) check will help to
distinguish it where you apply numeric checks on col B. Should do it ..

In A1, copied down:
=IF(AND(B1="-",C1="-"),"No Match",IF(AND(ISNUMBER(B1),B10,C1="Yes"),"SPINS
TOL",IF(AND(B1="-",C1="Yes"),"TOL",IF(AND(ISNUMBER(B1),B10,C1= "-"),"SPINS"))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CT" wrote:
In column A I need to return a value based on critera found in columns B and C.
If B1="-" and C1="-" return "No Match" in A1.
If B10 and C1="Yes" return "SPINS TOL" in A1.
If B1="-" and C1="Yes" return "TOL" in A1
If B10 and C1="-" return "SPINS" in A1.

Here is the formula I am using now.
=IF(AND(B1="-",C1="-"),"No Match",IF(AND(B10,C1="Yes"),"SPINS
TOL",IF(AND(B1="-",C1="Yes"),"TOL",IF(AND(B10,C1="-"),"SPINS"))))

Here are my results:
A B C
1 No Match - -
2 SPINS TOL 1 Yes
3 SPINS TOL - Yes
4 SPINS 2 -

I cannot get it to return "TOL" in A3. What am I doing wrong?