What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Excel Formula?

Excel Formula?
Author: Message:
Chocolatino
Full Member
***

Avatar
Money=Motivation

Posts: 207
Reputation: 10
31 / Male / Flag
Joined: Nov 2006
O.P. Undecided  Excel Formula?
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]
[Image: untitled2nk3.png]
01-14-2007 08:04 PM
Profile E-Mail PM Find Quote Report
YottabyteWizard
Senior Member
****

Avatar

Posts: 709
Reputation: 23
37 / Male / Flag
Joined: Mar 2005
RE: Excel Formula?
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.

This post was edited on 01-14-2007 at 08:07 PM by YottabyteWizard.
01-14-2007 08:07 PM
Profile E-Mail PM Find Quote Report
absorbation
Elite Member
*****

Avatar

Posts: 3636
Reputation: 81
– / Male / Flag
Joined: Feb 2005
RE: Excel Formula?
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 ;).
01-14-2007 08:08 PM
Profile PM Find Quote Report
Chocolatino
Full Member
***

Avatar
Money=Motivation

Posts: 207
Reputation: 10
31 / Male / Flag
Joined: Nov 2006
O.P. RE: Excel Formula?
worked perfect thanks ;)
[Image: untitled2nk3.png]
01-14-2007 08:10 PM
Profile E-Mail PM Find Quote Report
Voldemort
Veteran Member
*****

Avatar

Posts: 3504
Reputation: 49
– / – / Flag
Joined: Jul 2005
Status: Away
RE: Excel Formula?
i thought you would practice in excel with fake info....
*All posts are a purely speculative hypothesis based on abstract reasoning.
Not my daughter, you bitch!
[Image: ico-mollytrix16.gif]
01-14-2007 08:13 PM
Profile E-Mail PM Find Quote Report
RaceProUK
Elite Member
*****

Avatar

Posts: 6073
Reputation: 57
39 / Male / Flag
Joined: Oct 2003
RE: Excel Formula?
quote:
Originally posted by absorbation
=sum(I3*J3)
No need for sum() :P
[Image: spartaafk.png]
01-14-2007 08:46 PM
Profile PM Web Find Quote Report
Chocolatino
Full Member
***

Avatar
Money=Motivation

Posts: 207
Reputation: 10
31 / Male / Flag
Joined: Nov 2006
O.P. RE: Excel Formula?
quote:
Originally posted by Voldemort
i thought you would practice in excel with fake info....
It's for a project for a friend and he said to do it so i guess it's real.
[Image: untitled2nk3.png]
01-14-2007 09:02 PM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On