Thread
: [Solved]
Populating ranking depending upon ranges of previous cell's data
View Single Post
04-07-2016, 03:32 PM
sryder
Windows 10
Office 2013
Novice
Join Date: Apr 2016
Posts: 3
Quote:
Originally Posted by
xor
If I understand you correct:
=IF(D17>100,"",IF(D17>67,3,IF(D17>46,2,IF(D17>0,1, ""))))
Xor you're a genius! Thank you VERY much for your help, you've saved me a lot of headaches.
sryder
View Public Profile
Find all posts by sryder