Help with Percentage Formula

Occasional Visitor



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!



1 Reply
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)