I dont see anything in there that looks like what the result should be. It
looks like all you have is conditions.

What exactly do you want the formula to do?

"LMac" wrote:

Can anyone help me with a formula that looks at mutiple column values and
returns a specific value? Here is an example:

Class I If column 1 is ‰¤ 3000ppm; and cloumn 2 is ‰¤ 10ppg; and column 3 is ‰¤
5%; ‰¤ 10
Class II If column 1 is 3000ppm ‰¤ 10000ppm; and column 2 is 10ppg ‰¤
12ppg; and column 3 is 5% ‰¤ 10%
Class III If column 1 is 10000ppm; and column 2 is 12ppg; and column 3
is 10

Thanks, Lisa