How can I construct an IF statement to look over a range of cells in the logical test? I tried the following but it will not work.
I would like the statement to go if any cell in the range c21:j21 is equal to N/A then spit back 2 if not then 1
=IF(C21:J21="n/a",2,1)
Bookmarks