Forum Discussion
Help with Percentage Formula
Hello,
I'm looking to add a number plus 20% of that number to equal a fixed amount.
For example:
20% of 833,333 = 166,667
833,333 + 166,667 = 1,000,000
Assuming the only values we know are 1,000,000 and 20%, how do we find the values highlighted above?
Please see attached spreadsheet.
Thank you!
M
1 Reply
- Hi,
From what you mentioned. It works out as:
y = x + 0.2x
or y = 1.2x
from this we can work out that x = y / 1.2
so forumlas are, assuming you are in row 3
in B3 =(D3/1.2)
in C3 =(B3*0.2)
