I am looking for a formula to calculate a sum of a percentage correlated to the table on the right
Let me explain: I need the "Total" box to display the sum of the percentages indicated by the "Level" (LVL) box in the table.
For example: the number x is 100 and the LVL to its left is 5. I need the "Total" box to display the result of 100 + 5.34%, which is 105.34. Furthermore, each time I update the "LVL" box to a number between 1 and 15, the "Total" box should display the sum corresponding to that LVL in the table.
I'm not sure if I'm explaining this clearly, but I can't seem to create the correct formula.
-------------------------------------------------------------------------------------------------
Solved! I applied the formula thanks to user u/bachman460 (thanks pal) and slightly modified the percentage calculation by multiplying it by the number X so that the percentage is correlated with the number X. This solves the mathematical problem of adding percentages of the same number in question.
Example: 100 + 50% = 150 because 100 is added to its own 50%, which is 50.
Another example: 67 + 20% = 80.4 because 20% of 64 is 13.4 and is added to 67.
Thanks to the users for their help and for giving me some of their time.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience