Hi,
I need to create a formula to return values(1,2 or 3,) dependent on the top, middle and bottom percentage range in another column. So if the dependent cell value is 97.25% is should return 3, if its 10.1% return 1, etc(Max points for be in top 25%)
Any ideas? This novice is stumped
Thanks.
Bookmarks