| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula reflecting mutliple results
What formula to write on D column:
To show fail when theres an a or x on any column of A, B & C. To show pass when only b, or c or e (not a or x) on A, B & C columns. A B C D a a x fail c b x fail e c b pass e e a fail c b c pass c b b pass -- Aline Yiu |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula reflecting mutliple results
This formula should do the trick:
=IF(OR(A9="a",B9="a",C9="a",A9="x",B9="x",C9="x"), "fail","Pass") -- Kevin Backmann "Aline Yiu" wrote: What formula to write on D column: To show fail when theres an a or x on any column of A, B & C. To show pass when only b, or c or e (not a or x) on A, B & C columns. A B C D a a x fail c b x fail e c b pass e e a fail c b c pass c b b pass -- Aline Yiu |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula reflecting mutliple results
P.S. You'll have to replace the row number 9 with the relevant row for your
layout. I just happened to insert the formula in row 9 -- Kevin Backmann "Aline Yiu" wrote: What formula to write on D column: To show fail when theres an a or x on any column of A, B & C. To show pass when only b, or c or e (not a or x) on A, B & C columns. A B C D a a x fail c b x fail e c b pass e e a fail c b c pass c b b pass -- Aline Yiu |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula reflecting mutliple results
This array formula only checks for "a" or "x".
=IF(OR((A1:C1="a"),(A1:C1="x")),"Fail","Pass") Ctrl+Shift+Enter -- Dana DeLouis "Aline Yiu" wrote in message ... What formula to write on D column: To show "fail" when there's an "a" or "x" on any column of A, B & C. To show "pass" when only "b", or "c" or "e" (not a or x) on A, B & C columns. A B C D a a x fail c b x fail e c b pass e e a fail c b c pass c b b pass -- Aline Yiu |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula reflecting mutliple results
If you can always just have Pass/Fail (only depend on a's and x's):
=IF(SUM(COUNTIF(A1:C1,{"a","x"}))0,"Fail","Pass") If you can have other options besides a,x, b,c,e: =IF(SUM(COUNTIF(A3:C3,{"a","x"}))0,"Fail", IF(SUM(COUNTIF(A3:C3,{"b","c","e"}))0,"Pass","Und efined")) If you're going to compose in MSWord, you should turn those smart quotes off. It really clutters up your message's intent. Maybe composing in NotePad would be better???? Aline Yiu wrote: What formula to write on D column: To show fail when theres an a or x on any column of A, B & C. To show pass when only b, or c or e (not a or x) on A, B & C columns. A B C D a a x fail c b x fail e c b pass e e a fail c b c pass c b b pass -- Aline Yiu -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHART REFLECTING WIND AGAINST AN OBJECT IN DEGREES EACH DAY | Charts and Charting in Excel | |||
| ranking by mutliple categories | Excel Worksheet Functions | |||
| Stacked Column graphs reflecting net totals | Charts and Charting in Excel | |||
| Master Worksheet reflecting sub-worksheets | New Users to Excel | |||
| Maintain mutliple original formats in a formula result | Excel Worksheet Functions | |||
Linear Mode
