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...
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)
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)