|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 18th, 2006, 11:59 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
problem with formula
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 
|
|
#2
March 19th, 2006, 12:15 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formula
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
|
|
#3
March 19th, 2006, 12:19 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formula
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=number=percentage, select the decimal you want, and enter in cell A3 enter a formula such as =A2*whatever -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=523971
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting: problem entering EOMONTH formula... | Jonathan Cooper | General Discussion | 0 | February 6th, 2006 09:34 PM |
| conditional formatting: problem entering EOMONTH formula... | Jonathan Cooper | General Discussion | 1 | February 6th, 2006 09:28 PM |
| INDEX & MATCH formula problem | securityman | Worksheet Functions | 5 | September 6th, 2004 04:25 AM |
| Copy formula problem | AWilliams722 | Worksheet Functions | 0 | November 13th, 2003 10:37 PM |
| Formula Bar Problem... | Cloaked | Setting up and Configuration | 3 | October 4th, 2003 01:04 AM |
Linear Mode
