| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Aricaan
Cobra Corp
5
   |
Posted - 2012.08.26 18:41:00 -
[1] - Quote
Im using google docs, so not sure how much different it is on other software.
I got a number in B2 cell, and another number in the C2 cell.... I want their sum in the d2 cell...
SUM(D2)=C2*B2
Seems right? Right?
How do I enter this in the D2 cell....
Ive looked up a few you tube vids, and they say go up to insert.. but that function in insert isnt there anymore. Also, googles help files are useless. The only thing I have seemed to get work, is Ill write this formula in another box, and it just checks the math. I dont want my document so much to check it, but actually do the math... ya dig?
Free iskies to the first to help. Thanks.
There was an old mineral calculator I used to use on eve geek, but it seems eve geek has gone away. |
Aricaan
Cobra Corp
5
|
Posted - 2012.08.26 19:09:00 -
[2] - Quote
Someone helped me out in Mining Chat... sorry for spam  |
Steve Ronuken
Fuzzwork Enterprises
582
|
Posted - 2012.08.26 23:07:00 -
[3] - Quote
On the offchance someone comes across this, wanting a similar answer:
=sum(b2,c2)
If you want to sum a bunch of figures
=sum(b2:f2)
will sum everything from b2 to f2
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Aricaan
Cobra Corp
5
|
Posted - 2012.08.27 02:44:00 -
[4] - Quote
Well actually, I needed to type in my formula in a box on top of the spreadsheet, as opposed to inside the cell, and it worked. Turned out that was my problem. |
Sigras
Conglomo
IMPERIAL LEGI0N
184
|
Posted - 2012.08.27 06:59:00 -
[5] - Quote
no, that wasnt the problem.
Picture the cell as a variable, and what you type into the cell is what youre setting the variable to.
you should always start an equation in excel/google docs etc with a "=" there should be nothing left of the "=" |
Abdiel Kavash
Paladin Order
Fidelas Constans
836
|
Posted - 2012.08.27 13:01:00 -
[6] - Quote
Uhh is there anything wrong with simply "=C2 + B2"? Why would you even think of using multiplication when you want to sum up? |
Caelis Boirelle
Aurora Investments
20
|
Posted - 2012.08.27 13:25:00 -
[7] - Quote
Aricaan wrote:.
SUM(D2)=C2*B2
Err, nope.
SUM(D2)=C2+B2
PRODUCT(D2)=C2*B2
But yeah as has been mentioned previously of you want a cell to give you the sum of two other cells you need to enter it into the particular cell like this:
=SUM(B2:C2)
Or just type =Sum( then select the cells you want and it'll automatically fill with the correct numbers, then close it again with a second ).
Simples! |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |