| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula reflecting mutliple results--continued
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 undefined when ? on any column of A, B, & C -To show pass when only b, or c or e (not a or x or ?) on A, B & C columns. A B C D a a x fail c b a fail e c b pass a a fail e e a fail c b c pass c b b pass c b ? undefined e ? undefined Kevin, Dana and Dave thank you for your help. Ive put more conditions, hopefully theres a way to come up with a formula. -- Aline Yiu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula reflecting mutliple results | Excel Discussion (Misc queries) | |||
| 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 | |||
| Continued.....answer 8 - 1.2 = 6.2 from a formula | Excel Worksheet Functions | |||
Threaded Mode
