You can't do it that way. You will have what's called a circular reference.
You need to use another cell.

Enter your value in D1. Then calculate the percentages in E1:G1. Then use
another cell, say, H1 to calculate the grand total.

--
Biff
Microsoft Excel MVP


"Dors1309" wrote in message
...
Hi

I have the following cells

D1 = GRAND TOTAL (including E1, F1 and G1 amounts)
E1 = 10% of D1
F1 = 7% of D1
G1 = 5% of D1

When I put a figure into D1 I want to autopopulate E1, F1 and G1, but at
the
moment it is doing the percentages on top of the total in D1. These
percentages help make up the D1 total. Can anyone help
--
Dorsie