This is my first post on the forum. I've been grapling with this for days and am glad I found this forum.
My math problem is this. I need a formula to calculate percentages of a numbers range with negative numbers. More specifically, I'm using golf scores and need to calculate percentage as a range of scores for a given round.
For example if -8 is the low round and +8 is the high round, I need all other scores as a percentage. How can I express this in excel with a formula?
I know -8 would be 1.000% and +8 .000% but how do I formulate all the other scores in between?
Thank you so much in advance.