Populating ranking depending upon ranges of previous cell's data

xor · #1 04-06-2016, 09:19 PM

If I understand you correct:

=IF(D17>100,"",IF(D17>67,3,IF(D17>46,2,IF(D17>0,1, ""))))

sryder · #2 04-07-2016, 03:32 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation List based on Two Named Ranges	Rich18144	Excel	4	01-14-2016 04:37 AM
Populating a table cell wit document properties	milena	Word VBA	2	04-15-2015 07:28 AM
Problem with have a chart with different data ranges	expert4knowledge	Excel	2	09-09-2014 06:27 AM
VBA to immediately change the colour of a cell depending on the code placed in anothe	Phil Payne	Excel Programming	2	07-27-2013 11:04 PM
Show different Data depending on Imput Value	Aton	Word	0	09-15-2010 03:43 AM