Just an option to try ..

Assuming the reference table below is
in Sheet1, A1:D8
(i.e. w/o the dashes and the commas)

1a - high R, high HR, high %
1b - high R, high HR, low %
1c - high R, low HR, high %
1d - high R, low HR, low %
2a - low R, high HR, high %
2b - low R, high HR, low %
2c - low R, low HR, high %
2d - low R, low HR, low %

In Sheet2
-------------
Assuming you have other formulas
(in cols A to C, row2 down)
which evaluate to these sample text strings:

high R high HR high %
high R high HR low %
high R low HR high %
etc

Put in D2:

=IF(ISNA(MATCH(TRIM(A2&B2&C2),TRIM(Sheet1!$B$1:$B$ 8&Sheet1!$C$1:$C$8&Sheet1!
$D$1:$D$8),0)),"",INDEX(Sheet1!$A$1:$A$8,MATCH(TRI M(A2&B2&C2),TRIM(Sheet1!$B
$1:$B$8&Sheet1!$C$1:$C$8&Sheet1!$D$1:$D$8),0)))

Array-enter the formula in D2,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

Copy D2 down

For the sample data shown,
you'll get the desired results returned in col D:

high R high HR high % 1a
high R high HR low % 1b
high R low HR high % 1c

Any unmatched text string concats will return blanks: ""
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Luke Dallman" wrote in message
.. .
I need to evaluate the contents of three cells and return one of 8
choices in a fourth cell. The contents of the cells to be evaluated are
numbers and are compared to a given number as either "<" or "=".
The choices to return are 1a thru 1d or 2a thru 2d.

R HR % D
5 8 8 1a etc.

I have nested IF and AND functions, but can't figure out how to get past
the 7 nested functions limitation.
The formula works for 7 of the sets of conditions, but not the 8th.

The criteria a
1a - high R, high HR, high %
1b - high R, high HR, low %
1c - high R, low HR, high %
1d - high R, low HR, low %
2a - low R, high HR, high %
2b - low R, high HR, low %
2c - low R, low HR, high %
2d - low R, low HR, low %

Thanks in advance for any thoughts or suggestions.

Regards,

Luke