Help with Percentage Formula

Occasional Visitor

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)