Populating ranking depending upon ranges of previous cell's data

		Microsoft Office Forums > Microsoft Excel > Excel
Populating ranking depending upon ranges of previous cell's data

04-06-2016, 09:19 PM

xor

Windows 10 Populating ranking depending upon ranges of previous cell's data

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

If I understand you correct:

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:27 PM.