Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list on quintile values for monthly rainfall totals. ie ..
A B C D E F G H Quin 0 1 2 3 4 5 6 Jan 0-0 1-10 11-23 24-58 59-80 81-90 91 and greater Row 1 containns the monthly QUINTILE values from 0 to 6, and Row 2 has the average monthly rainfall range for each month. Under JAN, there are the other 11 months along with the differing mthly quintile values, tho that is to be ignored here. My problem - how can I return the correct quintile value returned for the monthly rainfall stored in cell named "MonthlyRainfall"? For example, "MonthlyRainfall" = 25 How do I have the quintile of "3" returned in a cell? Any ideas would be greatfully appreciated. Kaye |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Quartile funciton...quintile? | Excel Discussion (Misc queries) | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Quartile / Quintile Function | Excel Worksheet Functions |