Thread: How to input a range in a logical test?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Help Me Rhonda TOA[_2_] Help Me Rhonda TOA[_2_] is offline
external usenet poster
  
Posts: 18
Default 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 --
Reply With QuoteReply With Quote