google docs spreadsheet - simple formula help! - Discussion Forum

This is the static archive of the Massassi Forums. The forums are closed indefinitely. Thanks for all the memories!

You can also download Super Old Archived Message Boards from when Massassi first started.

"View" counts are as of the day the forums were archived, and will no longer increase.

google docs spreadsheet - simple formula help!

2009-12-24, 2:38 PM #1

happydud

Didn't go boom.

Posts: 6,837

Hey,
I have two columns of numbers, and I want the difference between column C and B to appear in column D. I can't figure out how to write one formula and have it output to more than one cell.

ex:

Code:

B    C    D
4    2    ?
2    5    ?
6    6    ?

I want one formula that outputs to all of those ?'s. I spent about 20 minutes on it (a lot longer than it would have taken to just do it manually) and can't figure it out. Tried to google, but couldn't come up with anything.

Thanks Massassi!

My Parkour blog
My Twitter. Follow me!

2009-12-24, 3:24 PM #2

Molgrew

Giddyup 409

Posts: 1,557

first row?
`=C1 - B1` in D1, enter, select D1 cell, grab lower-right handle, pull down

2009-12-24, 8:36 PM #3

happydud

Didn't go boom.

Posts: 6,837

Augh I'm dumb. I was trying to expand it before I hit enter.

Thanks! I really appreciate it!

My Parkour blog
My Twitter. Follow me!

2009-12-24, 9:23 PM #4

I am the Stig

Posts: 10,922

more like happydumb

[01:52] <~Nikumubeki> Because it's MBEGGAR BEGS LIKE A BEGONI.

2009-12-25, 1:06 AM #5

saberopus

Likes Kittens. Eats Fluffies

Posts: 12,306

more like dumbydud

2009-12-25, 8:37 AM #6

NoESC

CAPTAIN RAINBOWS. lol

Posts: 4,862

more like dumbydumb

gbk is 50 probably

MB IS FAT

2009-12-25, 9:33 AM #7

Couchman

Idaho Potato

Posts: 2,282

more like happystud

2009-12-25, 3:13 PM #8

Tibby

Ribberium Mempyre!

Posts: 12,497

more like couchwoman