Log In
Register
Home
December 24, 2018
Offline
Hi Mynda Treacy
Please guide ma how can I found value from two amount suppose there is a value of 1 to 100. we arrange it (1 to 25) = 2, (26 to 50) = 3, (51 to 75) = 4, and (76 to 100) = 5, in excel sheet for your understanding i have attached a sheet,
VIP
Trusted Members
December 7, 2016
Offline
Hello Salim,
No file was uploaded.
Br,
Anders
December 24, 2018
Offline
Dear Anders Sehlstedt
Thanks for reply, now I have attached file which clear you what formula of excel I want,
VIP
Trusted Members
December 7, 2016
Offline
Hello Salim,
You just need an ordinary VLOOKUP formula for that. You can of course use INDEX and MATCH or XLOOKUP also.
=VLOOKUP(E10,D3:F6;3,TRUE)
Br,
Anders
December 24, 2018
Offline
Dear Sir
Let me explain you, suppose there is a marksheet of different subject, each subject has different numbers of marks, for calculation of grades, 50 to 60 equal to grade 2, 61 to 70 equal to grade 3 and so on.. Now I want a excel formula which tell grades of taken marks, when we put a certain number between 50 to 60 in one cell other cell show grade
A = B
56 = 2
59 = 2
62 = 3
68 = 3
75 = 4
from above data you will understand easily as we put number of marks in cell A, Cell B show automatically grade number by the help of formula
November 3, 2015
Offline
Hi Salim,
Anders formula works but has a typo.
It should be:
=VLOOKUP(E10,D3:F6,3,TRUE)
Cheers
Graham
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Thanks Graham for correcting my error. In Swedish the separator is the semicolon, so when I paste in a formula copied from Excel I have to change to a comma, apparently missed that one.
Br,
Anders
1 Guest(s)
