lundi 1 août 2016

finding a number within a range within an if statement

I am attempting to create an IF statement that will use the contents of a cell (A1) within a range (G2:G11), which if found will show the word "Multi", otherwise blank "".

The formula I am attempting to use is =IF(A2=G2:G11,"Multi",""). I can find the first number within the range, but no other number within the range when I tested it. Any help would be appreciated. Than you in advance.

Aucun commentaire:

Enregistrer un commentaire