formula or function help

[dm]

I need to multiply 800 (a known number in column A)by
(100+?%)in column B, by 102% in column C, by (1+?%)in
column D, by 102% in column E, by (1+?%)in column F, by
102% in colum G to equal 1000 (a known number)in column
H. The percentages in columns B, D, & F need to be as
equal as possible.

 

[JE McGimpsey]

One way:

B1: =(H1/A1/1.02^3)^(1/3)
D1: = B1
F1: = B1

 

[Ron Rosenfeld]

I need to multiply 800 (a known number in column A)by
(100+?%)in column B, by 102% in column C, by (1+?%)in
column D, by 102% in column E, by (1+?%)in column F, by
102% in colum G to equal 1000 (a known number)in column
H. The percentages in columns B, D, & F need to be as
equal as possible.

? = 0.056095436290204

I put the appropriate formulas in B:G and used Goal Seek.


--ron