Thread
:
Use of IF with arrays
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
Use of IF with arrays
Try it like this:
=IF(COUNTIF(G6:G15,"MAPPED TO:")=ROWS(G6:G15),"MAPPED TO:","NEED TO MAP:")
Or, this array** version:
=IF(AND(G6:G15="MAPPED TO:"),"MAPPED TO:","NEED TO MAP:")
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"Andrew L" <Andrew
wrote in message
...
I am using the IF operator to test for the presence of a text string value
in
an array. My results indicate the formula is testing only the first cell
in
the array. How can I get the formula to evaluate each cell in the array?
My formula:
=IF(G6:G15="MAPPED TO:","MAPPED TO:","NEED TO MAP:")
The Microsoft Help documentation of IF states: "If any of the arguments to
IF are arrays (array: Used to build single formulas that produce multiple
results or that operate on a group of arguments that are arranged in rows
and
columns. An array range shares a common formula; an array constant is a
group
of constants used as an argument.), every element of the array is
evaluated
when the IF statement is carried out."
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko