Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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",""))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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",""))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |