Thread: percentages
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kthornton
 
Posts: n/a
Default 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