I saw a post that the percentages within range calculator wasn’t working?
I have set up a spreadsheet that calculate percentages within range, but I have no idea how to share it other than attaching to an email - suggestions please? But hopefully this post will help.
Percentages within range
In words, this is what I do 😊👍
Result minus Bottom of range
Divided by
Top of range minus Bottom of range
Then x 100
= percentages within range
Eg. Blue Horizon result
FT4 9.8 ug (7.9 - 14)
9.8 - 7.9
______________ x 100 = 31 %
14 - 7.9
Written by
Charlie-Farley
To view profiles and participate in discussions please or .
The ability to reply to this post has been turned off.
I have a spreadsheet that you can literally plug in your numbers to without worrying about formulas - it just spits out the answer - It's just how to Share ??. I use Libre office which is a Microsoft compatible shareware. They ask for a contribution (I give a £10 per year), Its not as expensive or 'topheavy' as Microsoft, which slows my computer down with it's top heavy programming. Libre is similar to the older versions of office (and doesn't make my computer grind to a halt) 😂
picture of spreadsheet to calculate percentages within range
Snap! Lol! It is good to have the formula and be able to do it by hand (well plus calculator) isn’t it! 😊👍. I eventually incorporated it into a record sheet on a spreadsheet package (still got my bit of paper though!)
I hated maths at school the teacher for my first four years at comprehensive school terrified me. I spent lessons trying to stop fearful sweat rolling out of my shirt sleeves. Literally 😱
Thankfully I was put into another teacher’s class last year because I was struggling. He was great and that last year I blossomed. Fear stunts learning.
Sort waffling again! Night night 🥱😴
The ability to reply to this post has been turned off.
Content on HealthUnlocked does not replace the relationship between you and doctors or other healthcare professionals nor the advice you receive from them.
Never delay seeking advice or dialling emergency services because of something that you have read on HealthUnlocked.