| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make formula more simple --- array?
Hi Nikki,
If your cells are adjacent: =IF(SUMPRODUCT(--(A1:A20="PASS"))=COUNTA(A1:A20),"PASS","FAIL") =IF(SUMPRODUCT(--(A1:A20="FAIL"))0,"FAIL","PASS") If not, array-enter for example: =IF(SUM(--(A1="FAIL"),--(A7="FAIL"),--(A9="FAIL"))0,"FAIL","PASS") Regards, Bernd |
| 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 | |||
Threaded Mode
