percentages
 

I have a spread sheet that breaks down costs of a product by country of
origin. I want to be able to fill in a unit price in one cell and then have
that number broken out by set percentages in other cells. How do I do this?

Example:

a1 = 2144.00

b2 = 25% b3 = 536
c2 = 50% c3 = 1072
d2 = 25% d3 = 536

percentages
 

=B2*A1 in B3
=C2*A1 in C3
=D2*A1 in D3
--
Gary's Student


"kthornton" wrote:

I have a spread sheet that breaks down costs of a product by country of
origin. I want to be able to fill in a unit price in one cell and then have
that number broken out by set percentages in other cells. How do I do this?

Example:

a1 = 2144.00

b2 = 25% b3 = 536
c2 = 50% c3 = 1072
d2 = 25% d3 = 536