How to input a range in a logical test?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 (e-mail address removed) --
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to compute this formula: =IF(Q48=Protected!C27:C35,+Q48,"". 2
How to define a drop down row filter in cell C2 for cells C3:C27 ? 2
Averaging without #DIV0! 11
Error putting a formula in a cell with vba 4
REFERENCING cell reference 1
If condition for Blank Cell 4
Replacing a value from a formula 1
Multiple Target as Excel Range 1

Back
Top