How to input a range in a logical test?
 

When I input this formula: =IF(Q48=Protected!C27,+Q48,"") -- I get the
expected result,

but if I replace Protected!C27 with Protected!C27:C35,

I get # signs in the cell where my formula should be. What is the problem?"

Please respond to --

How to input a range in a logical test?
 

Do you want to find out whether Q48 matches any of the cells C27:C35?? If
you do, use the MATCH function. X=Range has no meaning in a formula.

Stan

"Help Me Rhonda TOA" wrote in
message ...
When I input this formula: =IF(Q48=Protected!C27,+Q48,"") -- I get the
expected result,

but if I replace Protected!C27 with Protected!C27:C35,

I get # signs in the cell where my formula should be. What is the
problem?"

Please respond to --