Help with Percentage Formula

[MiRod1220]

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

[#2]

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)