Need an Xcel Formula asap

[paz]

hey all. what i need is a formula to work out percentages to be writen into an excel spread sheet, got me stuffed how to work it out. basically all the info i can give is-
c2=12 (total)
d2=2 (added on)
e2=10 (original)
f2=20% (this is what i need, f2 is the percentage that is added onto e2 to get the total that is c2. i know all the other figures, just need a formula to work out the percentage though)

paz

[Dan96XJ]

i usually divide say 2 / 10 *100 = 20

so type this in the cell F2 =(D2/E2)*100

[Hurdbeast]

try this in F2 =SUM(D2/E2) then enter. answer given will be 20. but if you go to format in the toolbar and format cell, under the number tab, click percentage, change decimal places to zero and you should have the answer of 20% in F2
Also if you know about the autosum button in the toolbar you can simply select the cell you want the answer in and then use the + - / * buttons to add cells to the equation i.e Click cell F2 then left click auto sum then left click D2, press / then left click E2 then press enter. the autosum button looks like a greek symbol.
Oh Yeah i dont mean to insult your intelligence. just making sure you can do it the easy way

[paz]

thanks gents, greatly appreciated, im a dumb ass when it comes to stuff like that. be ready for some more stupid questions as i tackle more of the xcel spreadsheet im trying to set up

Paz

[Hurdbeast]

hey happy to help. i set up a few spreadsheets in my time. dont hesitate to ask