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."