| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for giving point to particular no.
I have random numbers in A column I want a formula for conditions given below
Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
Do you mean that if A1 contains 76, the formula should return 1, if A2
contains 71, the formula should return 2, etc.? Stefi €˛kashish€¯ ezt Ć*rta: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
Try this with value in A1
=LOOKUP(A1,{0,26,46,51,56,61,66,71,76},{9,8,7,6,5, 4,3,2,1}) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
Yes
For example A B 78 1 50 7 65 4 63 4 80 1 23 9 "Stefi" wrote: Do you mean that if A1 contains 76, the formula should return 1, if A2 contains 71, the formula should return 2, etc.? Stefi €˛kashish€¯ ezt Ć*rta: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
It is exactly that I want thank you
another problem A has value like below and I want a formula for B's value A B Above 7 0 7 0 8 1 6 2 5 3 4 4 3 5 2 6 1 7 "Jacob Skaria" wrote: Try this with value in A1 =LOOKUP(A1,{0,26,46,51,56,61,66,71,76},{9,8,7,6,5, 4,3,2,1}) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
Do you mean
=IF(A28,0,LOOKUP(A2,{1,2,3,4,5,6,7,8},{7,6,5,4,3, 2,0,1})) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: It is exactly that I want thank you another problem A has value like below and I want a formula for B's value A B Above 7 0 7 0 8 1 6 2 5 3 4 4 3 5 2 6 1 7 "Jacob Skaria" wrote: Try this with value in A1 =LOOKUP(A1,{0,26,46,51,56,61,66,71,76},{9,8,7,6,5, 4,3,2,1}) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
Again thanks but how can i use following formula for ascending order up to
100 and so on =LOOKUP(A32,{1,2,3,4,5,6,7,8,9,10},{5,10,15,20,25, 30,35,40,45,50,55}) "Jacob Skaria" wrote: Do you mean =IF(A28,0,LOOKUP(A2,{1,2,3,4,5,6,7,8},{7,6,5,4,3, 2,0,1})) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: It is exactly that I want thank you another problem A has value like below and I want a formula for B's value A B Above 7 0 7 0 8 1 6 2 5 3 4 4 3 5 2 6 1 7 "Jacob Skaria" wrote: Try this with value in A1 =LOOKUP(A1,{0,26,46,51,56,61,66,71,76},{9,8,7,6,5, 4,3,2,1}) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for giving point to particular no.
???
=A32*5 If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: Again thanks but how can i use following formula for ascending order up to 100 and so on =LOOKUP(A32,{1,2,3,4,5,6,7,8,9,10},{5,10,15,20,25, 30,35,40,45,50,55}) "Jacob Skaria" wrote: Do you mean =IF(A28,0,LOOKUP(A2,{1,2,3,4,5,6,7,8},{7,6,5,4,3, 2,0,1})) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: It is exactly that I want thank you another problem A has value like below and I want a formula for B's value A B Above 7 0 7 0 8 1 6 2 5 3 4 4 3 5 2 6 1 7 "Jacob Skaria" wrote: Try this with value in A1 =LOOKUP(A1,{0,26,46,51,56,61,66,71,76},{9,8,7,6,5, 4,3,2,1}) If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7 26-45 8 0-25 9 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula giving wrong result | Excel Worksheet Functions | |||
| Sumif formula not giving result | Excel Discussion (Misc queries) | |||
| Formula not giving me the right result | Excel Worksheet Functions | |||
| My formula Is giving me a #NAME! | Excel Worksheet Functions | |||
| same formula giving diff resutls | Excel Worksheet Functions | |||
Linear Mode
