Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calc #'s giving totals 1-15=1, 16-25=2, 26-35=3, etc
I need a formula that can calc #'s giving totals: 1-15=1, 16-25=2, 26-35=3,
etc. So that when I plug in say 9, in the first column, I get 1 as the total in the next column but if I plug in 18, I get 2, etc. This is for a school physical workout challenge with different points being awarded according to repetitions done. The first column contains the no. of reps and the second column contains the points awarded. The formula has to include all reps/points increments in the range from 1-60 reps and 1-5 points. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calc #'s giving totals 1-15=1, 16-25=2, 26-35=3, etc
Try...
=LOOKUP(A2,{-9.99999999999999E+307,1,16,26,36,46},{0,1,2,3,4,5} ) Adjust the thresholds for the first array constant {...} accordingly. Hope this helps! In article , Yang-Um wrote: I need a formula that can calc #'s giving totals: 1-15=1, 16-25=2, 26-35=3, etc. So that when I plug in say 9, in the first column, I get 1 as the total in the next column but if I plug in 18, I get 2, etc. This is for a school physical workout challenge with different points being awarded according to repetitions done. The first column contains the no. of reps and the second column contains the points awarded. The formula has to include all reps/points increments in the range from 1-60 reps and 1-5 points. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calc #'s giving totals 1-15=1, 16-25=2, 26-35=3, etc
Another play ..
Assume data (no. of reps) will be entered in A1 down Put in B1: =IF(A1="","",VLOOKUP(A1,{1,1;16,2;26,3;36,4;46,5}, 2)) Copy down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Yang-Um" wrote: I need a formula that can calc #'s giving totals: 1-15=1, 16-25=2, 26-35=3, etc. So that when I plug in say 9, in the first column, I get 1 as the total in the next column but if I plug in 18, I get 2, etc. This is for a school physical workout challenge with different points being awarded according to repetitions done. The first column contains the no. of reps and the second column contains the points awarded. The formula has to include all reps/points increments in the range from 1-60 reps and 1-5 points. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i create formula giving totals based on financial & text info | Excel Discussion (Misc queries) |