Forum

Notifications
Clear all

how to set a formula of a common value or number from two different amount

8 Posts
3 Users
0 Reactions
156 Views
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

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, 

 
Posted : 07/07/2021 6:19 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello Salim,

No file was uploaded.

Br,
Anders

 
Posted : 07/07/2021 4:07 pm
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

Dear Anders Sehlstedt 

Thanks for reply, now I have attached file which clear you what formula of excel I want,  

 
Posted : 08/07/2021 2:20 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

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

 
Posted : 08/07/2021 8:25 am
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

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 

 
Posted : 09/07/2021 2:27 am
(@stentg)
Posts: 18
Eminent Member
 

Hi Salim,

Anders formula works but has a typo.

It should be:

=VLOOKUP(E10,D3:F6,3,TRUE)

Cheers

Graham

 
Posted : 10/07/2021 11:06 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

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

 
Posted : 10/07/2021 4:15 pm
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

Dear every one

Thanks for guidance 

 
Posted : 11/07/2021 3:36 am
Share: