I apologize if this has been asked before, but I cannot find a relevant post.
I have a simple IF function where I compare a value of a cell to a named range (also a single cell). Like this ...
In the case above, the named range, "display_years" = 15 and the value of cell AM$268 = 2047, but the result of the logical test is FALSE.
If I remove all references to a named range, the logical test will work fine. For example,
Can some one explain why this happening?
Thanks,
Steve
I have a simple IF function where I compare a value of a cell to a named range (also a single cell). Like this ...
=IF(AM$268 > display_years,TRUE,FALSE) ... display_years is the named range that is a single cell.
In the case above, the named range, "display_years" = 15 and the value of cell AM$268 = 2047, but the result of the logical test is FALSE.
If I remove all references to a named range, the logical test will work fine. For example,
=IF(AM$268 > $AQ$264,TRUE,FALSE) ... where $AQ$264 = 15, the result of the logical test is TRUE
Can some one explain why this happening?
Thanks,
Steve