Hi,
I need some formula help here in the following situation.
File is enclosed & mentioned my results expectation.
Column A will have numbers. I need to find that between a range of numbers (1-10, 11-20, 21-30, 31-40, 41-50) and i should get yes as answer. and also i shall get "Yes" as prior to the range also.
For Ex: In Cell A1 number 25 is in between a range of 21-30, so i should get yes for range 1-10 & 11-20 also.
If my cell A1 value is 42 then all the ranges shall be yes.
If my cell A1 value is 7 then only 1-10 range should have answer as yes.
Bookmarks