Excel Formula? - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Excel Formula? (/showthread.php?tid=70690)
Excel Formula? by Chocolatino on 01-14-2007 at 08:04 PM
What Formula do it put in so that coloumn I gets Timed ( X ) by coloumn J and the answer comes up in coloumn k? Never been good with excel 
Tnx in advance.
![[Image: untitledkq3.jpg]](http://img444.imageshack.us/img444/8417/untitledkq3.jpg)
RE: Excel Formula? by YottabyteWizard on 01-14-2007 at 08:07 PM
I don't know if you mean a multiplication, but if you do, this is how you must do it.
On the K3 cell you have to type
=I3*J3
Then you copy that formula and paste it on all the others cells below, it will modify the formula automatically for each cell.
RE: Excel Formula? by absorbation on 01-14-2007 at 08:08 PM
Enter this into K3:
=sum(I3*J3)
On the edge of the cell (bottom right) click the square and drag down, to auto-complete your results 
.
RE: Excel Formula? by Chocolatino on 01-14-2007 at 08:10 PM
worked perfect thanks
RE: Excel Formula? by Voldemort on 01-14-2007 at 08:13 PM
i thought you would practice in excel with fake info....
RE: Excel Formula? by RaceProUK on 01-14-2007 at 08:46 PM
quote:No need for sum()
Originally posted by absorbation
=sum(I3*J3)
RE: Excel Formula? by Chocolatino on 01-14-2007 at 09:02 PM
quote:It's for a project for a friend and he said to do it so i guess it's real.
Originally posted by Voldemort
i thought you would practice in excel with fake info....