General discussion

Locked

Excel: a number within a range

By brifd1 ·
I have 2 columns of #'s.
I want to check the # in (for instance) cell A4 vs. the range of #'s in C4:C35 to see if there is any # in that range within +5 or -5 of the value in cell A4.
What would the formula be that could do this?
Thanks for your ideas/help!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums