Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to do you work out persenages
how do i work out the forumula for dividing
|
#2
|
|||
|
|||
Hi Andy
not sure what you're really after but say you have the following ..........A.............B...............C 1.....................Value...........% 2.......................20 3.......................40 4.......................10 5........Total.......70 and you want to determine what percentage of the Total each value is (ie the formula for column C) then in C2 =B2/$B$5 and then fill down (move mouse over bottom right hand corner of the cell and when you see a + double click) (delete C5 if required) now select C2 through C4 and click on the % icon on the formatting toolbar if you don't want to use the % icon on the formatting toolbar the formula you need in C2 is =B2/$B$5*100 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "andy" wrote in message ... how do i work out the forumula for dividing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy the work sheets from different workbooks into one? | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
Lookup Doesn't Work | Excel Worksheet Functions |