Excel Formula
 

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

Excel Formula
 

is this what you are looking for/

=IF(AND(A1<=3000,B1<=10,C1<=5),"Class
I",IF(AND(A13000,A1<=10000,B110,B1<=12,C15,C1<= 10),"Class
II",IF(AND(A110000,B112,C110),"Class III","")))

Excel Formula
 

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

Excel Formula
 

Thank you so much, I will try it! Been struggling with it.
--
Lisa
LifeHapins


"~slacker~" wrote:

is this what you are looking for/

=IF(AND(A1<=3000,B1<=10,C1<=5),"Class
I",IF(AND(A13000,A1<=10000,B110,B1<=12,C15,C1<= 10),"Class
II",IF(AND(A110000,B112,C110),"Class III","")))