Autosum of various cells
 

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

Autosum of various cells
 

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

Autosum of various cells
 

You state D1 includes E1, F1, and G1. What else does it include? Say, for
example, you are trying to have D1 be =SUM(A1:C1) + E1+F1+G1, you could set
up the following formula in cells D1 through G1
E1: =SUM(A1:C1)*.1
F1: =SUM(A1:C1)*.07
G1: =SUM(A1:C1)*.05
D1: =SUM(A1:C1,E1:G1)
--
John C


"Dors1309" wrote:

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