Help with Percentage Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2799909%22%20slang%3D%22en-US%22%3EHelp%20with%20Percentage%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2799909%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20to%20add%20a%20number%20plus%2020%25%20of%20that%20number%20to%20equal%20a%20fixed%20amount.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E20%25%20of%20833%2C333%20%3D%20166%2C667%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23339966%22%3E%3CU%3E%3CSTRONG%3E833%2C333%3C%2FSTRONG%3E%3C%2FU%3E%20%3CFONT%20color%3D%22%23000000%22%3E%2B%3C%2FFONT%3E%20%3CSTRONG%3E%3CU%3E166%2C667%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FFONT%3E%20%3D%201%2C000%2C000%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20the%20only%20values%20we%20know%20are%201%2C000%2C000%20and%2020%25%2C%20how%20do%20we%20find%20the%20values%20highlighted%20above%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2799909%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2800016%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Percentage%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2800016%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EFrom%20what%20you%20mentioned.%20It%20works%20out%20as%3A%3CBR%20%2F%3Ey%20%3D%20x%20%2B%200.2x%3CBR%20%2F%3Eor%20y%20%3D%201.2x%3CBR%20%2F%3Efrom%20this%20we%20can%20work%20out%20that%20x%20%3D%20y%20%2F%201.2%3CBR%20%2F%3Eso%20forumlas%20are%2C%20assuming%20you%20are%20in%20row%203%3CBR%20%2F%3Ein%20B3%20%3D(D3%2F1.2)%3CBR%20%2F%3Ein%20C3%20%3D(B3*0.2)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
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)