formula or function help

D

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.
 
R

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.
Click to expand...

? = 0.056095436290204

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


--ron
 
Top