Microsoft Excel
--
Questions
--
Followers
Top Experts
Excel Score Formula
Hi Experts
I have a data set in excel, in which I have to give scores based on this criteria defined in 5 different ScoreSlabs. Please look at the excel sheet, that will clarify it instantly.
If [the cell value] is,, then give this Score
If >= ScoreSlab1 2
If >= ScoreSlab2 and < ScoreSlab1 1
If < ScoreSlab1 and > ScoreSlab4 0
If <= ScoreSlab4 and > ScoreSlab5 -1
If <= ScoreSlab5 -2
So basically each of the cells given at bottom of the excel sheet, will have any of these 5 values 2,1,0,-1,-2 .
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data.
Score-in-Excel-based-on-Criteria.xlsx
Thanks
I have a data set in excel, in which I have to give scores based on this criteria defined in 5 different ScoreSlabs. Please look at the excel sheet, that will clarify it instantly.
If [the cell value] is,, then give this Score
If >= ScoreSlab1 2
If >= ScoreSlab2 and < ScoreSlab1 1
If < ScoreSlab1 and > ScoreSlab4 0
If <= ScoreSlab4 and > ScoreSlab5 -1
If <= ScoreSlab5 -2
So basically each of the cells given at bottom of the excel sheet, will have any of these 5 values 2,1,0,-1,-2 .
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data.
Score-in-Excel-based-on-Criteria.xlsx
Thanks
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
"If you find the concept of ScoreSlab Confusing, then please assume the score slabs to be representing the numerical values from 4 to -4, as follows
4
2
0
-2
-1"
Yeah, that is not confusing at all! :)
Did you mean from 2 to -2?
4
2
0
-2
-1"
Yeah, that is not confusing at all! :)
Did you mean from 2 to -2?
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
I don't understand the meaning of the first conversion from ScoreSlab values to -4 to 4.
Direct conversion formula in I88 is
=IF(I28>=I$14,2,IF(I28>=I$
Meaning
If >= ScoreSlab1 Then 2
If >= ScoreSlab 2 and < ScoreSlab1 Then 1
If <= ScoreSlab5 then -2
If > ScoreSlab5 and <= ScoreSlab4 then -1
Else 0
Direct conversion formula in I88 is
=IF(I28>=I$14,2,IF(I28>=I$
Meaning
If >= ScoreSlab1 Then 2
If >= ScoreSlab 2 and < ScoreSlab1 Then 1
If <= ScoreSlab5 then -2
If > ScoreSlab5 and <= ScoreSlab4 then -1
Else 0
Thank you so much @ Raheman M.Abdul
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
You're welcome.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.