|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com