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
|