Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make formula more simple --- array?
Hi group,
I just have a quick question. I understand arrays (mostly?) and have found their use extremely convenient especially when typing out a "megaformula". However, I have this situation that has been bugging me lately in my various Excel work. Take the following formula: =IF (OR (W4 = "FAIL", W8 = "FAIL", W13 = "FAIL"), "FAIL", "PASS") That works perfectly, but it becomes a hassle when there's more than 3 values I'm comparing. Of course this can also be written: =IF (AND (W4 = "PASS", W8 = "PASS", W13 = "PASS"), "PASS", "FAIL") Same thing, works perfectly, but also becomes a hassle when there's more than 3 cells I'm comparing. What I'm looking for is a way to shorten this formula, like an array does with countless AND() functions. (W4:W8 -- except in this case the cells are not next to eachother) Make sense? Is that possible? Thank you in advance, Nikki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a simple check mark column? | Excel Discussion (Misc queries) | |||
Can I make a simple fill-in calculator for webpage using Excel? | Excel Discussion (Misc queries) | |||
Simple question- how to make X axis on bottom of chart | Charts and Charting in Excel | |||
Help please simple drop and drag I can't make work | Excel Worksheet Functions | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |