Hard Light Productions Forums

Off-Topic Discussion => General Discussion => Topic started by: Kosh on July 01, 2006, 08:25:46 pm

Title: Need Excel help pronto!
Post by: Kosh on July 01, 2006, 08:25:46 pm

I am trying to take a column and multiply everything in it by 4, How can I make Excel automate this? there are 52 rows that need to be calculated.

Title: Re: Need Excel help pronto!
Post by: Kosh on July 01, 2006, 08:35:55 pm

I've tried entering =G2:G54*4 but it will only do it for one cell.


I need to get this finished before this afternoon, please help now!

Title: Re: Need Excel help pronto!
Post by: redsniper on July 01, 2006, 09:06:27 pm

make a formula that multiplies one of the cells by 4. Like in G3 put =G2*4. Then copy that down the whole column and it should adjust the cell number appropriately.

Title: Re: Need Excel help pronto!
Post by: Mars on July 01, 2006, 09:56:14 pm

And use OpenOffice.org Calc while your at it  :p

Title: Re: Need Excel help pronto!
Post by: redsniper on July 02, 2006, 08:28:57 am

Did it work?

Title: Re: Need Excel help pronto!
Post by: Kosh on July 02, 2006, 08:35:06 am

Yes, thank you.


Now I am finally on summer vacation!!!!!!!!!!!!!!!!!!!!!!!