software

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: www.excelforum.com/member.php...oamp;userid=32596
View this thread: www.excelforum.com/showthread...hreadid=523971
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

quot;jpoltorquot; gt; wrote in
message ...
gt;
gt; Im new to the excel program
gt; What I would like to do is add three cells b1 e1 h1 and make them equal
gt; 100% then i would like in cell b2, b1=?% of 100%, e2, e1=?% of 100%, h2,
gt; h1=?% 0f 100%
gt;
gt; I would then like to turn the percent into a decimal and multiply that
gt; by a value in a different cell. I would like to do that for b3,e3, and
gt; h3
gt;
gt; Please help
gt; Thanks
gt; JP
gt;
gt;
gt; --
gt; jpoltor
gt; ------------------------------------------------------------------------
gt; jpoltor's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32596
gt; View this thread: www.excelforum.com/showthread...hreadid=523971
gt;
Enter this in A2
=A1/SUM($A$1:$C$1)

enter this in B2
=B1/SUM($A$1:$C$1)

enter this in C2
=C1/SUM($A$1:$C$1)

You can format the three cells to read as percentages
Highlite the cells(A2:C2), right click on the mouse and select format
cells=gt;number=gt;percentage, select the decimal you want, and enter

in cell A3 enter a formula such as
=A2*whatever--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=523971