Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF an array..
I am using the following formula:
=if( B2..Z2="n/a","Yes","No") in attempt retreive a "Yes" if any within the data set has a "n/a". The formula only retruns a"Yes" if the B2 cell is "n/a" - and otherwise returns "No" when "n/a" exists within the group. What is wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF an array..
=IF(COUNTIF(B2:Z2,"n/a")0,"Yes","No")
-- Gary''s Student - gsnu200792 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Goal Seek On Members of an Array within Array | Excel Worksheet Functions |