Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2016, 07:07 PM
sryder sryder is offline Populating ranking depending upon ranges of previous cell's data Windows 10 Populating ranking depending upon ranges of previous cell's data Office 2013
Novice
Populating ranking depending upon ranges of previous cell's data
 
Join Date: Apr 2016
Posts: 3
sryder is on a distinguished road
Default Populating ranking depending upon ranges of previous cell's data

Hi all, I received help with this spreadsheet before and now have a new hurdle I'd appreciate your help with.



I am trying to find the correct formula that will populate a ranking (1, 2, or 3) based on specified ranges of a previous cell's value.

Three cells in a column come into play on this. The top cell is a simple SUM, the middle cell is averages the SUM criteria to provide a %, and the bottom cell that I'm having trouble with is supposed to generate a ranking based on where the middle cell's value falls within three ranges (0%-45% = 1, 46% - 67% = 2, 68% - 100% = 3). I have attempted several formulas, here is what I've landed on:

=IF(D17<=45, 1, IF(D17<=67, 2, IF(D17<=100, 3, 0)))

I originally thought this would work:

=IF(D17<=45, 1, IF(D17>=46, D17<=67, 2, IF(D17>=47, D17<=100, 3, 0)))

I'm receiving an error re: too many arguments for the latter formula. Now I'm stuck.

Thank you in advance, please let me know if I can provide any further info that may help!
Reply With Quote
  #2  
Old 04-06-2016, 09:19 PM
xor xor is offline Populating ranking depending upon ranges of previous cell's data Windows 10 Populating ranking depending upon ranges of previous cell's data Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

If I understand you correct:

=IF(D17>100,"",IF(D17>67,3,IF(D17>46,2,IF(D17>0,1, ""))))
Reply With Quote
  #3  
Old 04-06-2016, 11:39 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Populating ranking depending upon ranges of previous cell's data Windows 7 64bit Populating ranking depending upon ranges of previous cell's data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please do not cross post without links. read this to understand why and act accordingly- Thx

http://www.excelguru.ca/forums/showt...us-cell-s-data
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 04-07-2016, 05:54 AM
NoSparks NoSparks is offline Populating ranking depending upon ranges of previous cell's data Windows 7 64bit Populating ranking depending upon ranges of previous cell's data Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

pecoflyer actually meant for you to read this
http://www.excelguru.ca/content.php?184
Reply With Quote
  #5  
Old 04-07-2016, 03:32 PM
sryder sryder is offline Populating ranking depending upon ranges of previous cell's data Windows 10 Populating ranking depending upon ranges of previous cell's data Office 2013
Novice
Populating ranking depending upon ranges of previous cell's data
 
Join Date: Apr 2016
Posts: 3
sryder is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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.
Reply With Quote
  #6  
Old 04-07-2016, 03:37 PM
sryder sryder is offline Populating ranking depending upon ranges of previous cell's data Windows 10 Populating ranking depending upon ranges of previous cell's data Office 2013
Novice
Populating ranking depending upon ranges of previous cell's data
 
Join Date: Apr 2016
Posts: 3
sryder is on a distinguished road
Default

Sorry about this, thank you for the information. Not my intention to be redundant or a pain.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populating ranking depending upon ranges of previous cell's data 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
Populating ranking depending upon ranges of previous cell's data 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:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft