| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Including a range of number in a IF (Logical Test) formula | Excel Worksheet Functions | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| How I set up as logical test if my range has to be >=2 but <5 | Excel Discussion (Misc queries) | |||
| logical test - within a range | Excel Worksheet Functions | |||
![Help Me Rhonda TOA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
