#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
If I understand you correct:
=IF(D17>100,"",IF(D17>67,3,IF(D17>46,2,IF(D17>0,1, "")))) |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
pecoflyer actually meant for you to read this
http://www.excelguru.ca/content.php?184 |
#5
|
|||
|
|||
Quote:
Xor you're a genius! Thank you VERY much for your help, you've saved me a lot of headaches. |
#6
|
|||
|
|||
Sorry about this, thank you for the information. Not my intention to be redundant or a pain.
|
Thread Tools | |
Display Modes | |
|
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 |