In B2 put

=B1/SUM($B$1,$E$1,$H$1)

in E2

=E1/SUM($B$1,$E$1,$H$1)

in H2

=H1/SUM($B$1,$E$1,$H$1)




--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"jpoltor" wrote in
message ...

Im new to the excel program
What I would like to do is add three cells b1+e1+h1 and make them equal
100% then i would like in cell b2, b1=?% of 100%, e2, e1=?% of 100%, h2,
h1=?% 0f 100%

I would then like to turn the percent into a decimal and multiply that
by a value in a different cell. I would like to do that for b3,e3, and
h3

Please help
Thanks
JP


--
jpoltor
------------------------------------------------------------------------
jpoltor's Profile:
http://www.excelforum.com/member.php...o&userid=32596
View this thread: http://www.excelforum.com/showthread...hreadid=523971