Formula for "score" plus a range

Kim1968

New Member
Joined
Jul 7, 2016
Messages
2
Hello,
I am recreating a calculator/table in Excel. There are 6 categories 2, 3, or 4 elements in each category. You choose the element in each category and it is assigned a score (both negative and positive). There is a total score and then a range. If I do a standard SUM then it will be incorrect. The highest score is 14 and the lowest is 0. If done correctly the risk score for this patient should be 4. Below is my spreadsheet and the link is the actual calculator that you can use, from the internet. What formula are the using to calculate the score?


Thanks!
Kim


REVEAL LITE 2 RISK CALCULATORSCORE
BNP (pg/ml)< 5050 to < 200200 to < 800≥ 800
-2012-2
NT-proBNP (pg/ml)< 300300 to < 1100≥ 1100
-202
6MWT (m)≥ 440320 to 440<320 to 165< 165
-2-1010
NYHA/WHO Functional ClassIIIIIIIV
-10120
Systolic BP SBP ≥ 110SBP ≤ 110
01 0
Heart Rate HR ≤ 96HR > 96
01 0
eGFR < 60ml/min/1.73m2 or renal insufficiency NoYes
01 0
RISK SCORE
RISK SCORELow RiskIntermediate RiskHigh Risk
≤ 56-7≥ 8
 
The calculator is taking the sum of the score for each category then adding 6 to that sum to get the total risk score. It even shows you that it is doing that.

In your example the total is -2.

-2 + 6 = 4

1739374428676.png
 
Upvote 0
Thank you. I wasn't sure why it was adding 6 to the score and if it was that easy! I will re-read the method/research.

Thank you!
Kim
 
Upvote 0
I am guessing that they add 6 because the lowest possible total score is -5 and they want the result to be a positive number. So the in the lowest-risk case the result is 1.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top