get value from total and percentage

[lauren1990]

OK, so I've googled and I can only find formulas for working out the percentage based on a total and a value where I need to work out the unknown value based on the percentage and the total

for example, where the total and percentages are known but the value of the percentage is unknown;

	Balanced
	$ 101,118.69
Cash	5%
Australian Shares	28%
International Shares	27%
Property	6%
Other	34%

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Krayons]

A balanced	B 100,000	C
cash	5%	$5,000.00
australian shares	28%	$28,000.00
international shares	27%	$27,000.00
property	6%	$6,000.00
other	34%	$34,000.00

<tbody>
</tbody>

you multiply the balanced amount by the percentage to determine the dollar value.

X = 100,000
Y = 5%
Z = ?

X * Y = Z

=$B$1*B2