HLP Network

News:

HLP Donations Page has been reworked for supporting the site.
Please note that the previous "Tiers" are currently not operational (but will be worked on).
You can still cancel any previous re-occurring donations to make new ones which will go to the new Treasurer Admin (Zacam).

 
« Previous Thread Next Thread »
Print
Pages: [1]   Go Down

Author Topic: Need Excel help pronto!  (Read 624 times)

0 Members and 1 Guest are viewing this topic.

Offline Kosh

  • A year behind what's funny
  • 210
Need Excel help pronto!
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.
"The reason for this is that the original Fortran got so convoluted and extensive (10's of millions of lines of code) that no-one can actually figure out how it works, there's a massive project going on to decode the original Fortran and write a more modern system, but until then, the UK communication network is actually relying heavily on 35 year old Fortran that nobody understands." - Flipside

Brain I/O error
Replace and press any key
 

Offline Kosh

  • A year behind what's funny
  • 210
Re: Need Excel help pronto!
Reply #1 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!
« Last Edit: July 01, 2006, 08:39:42 pm by Kosh »
"The reason for this is that the original Fortran got so convoluted and extensive (10's of millions of lines of code) that no-one can actually figure out how it works, there's a massive project going on to decode the original Fortran and write a more modern system, but until then, the UK communication network is actually relying heavily on 35 year old Fortran that nobody understands." - Flipside

Brain I/O error
Replace and press any key
  

Offline redsniper

  • 211
  • Aim for the Top!
Re: Need Excel help pronto!
Reply #2 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.
"Think about nice things not unhappy things.
The future makes happy, if you make it yourself.
No war; think about happy things."   -WouterSmitssm

Hard Light Productions:
"...this conversation is pointlessly confrontational."
 

Offline Mars

  • I have no originality
  • 211
  • Attempting unreasonable levels of reasonable
Re: Need Excel help pronto!
Reply #3 on: July 01, 2006, 09:56:14 pm
And use OpenOffice.org Calc while your at it  :p
 

Offline redsniper

  • 211
  • Aim for the Top!
Re: Need Excel help pronto!
Reply #4 on: July 02, 2006, 08:28:57 am
Did it work?
"Think about nice things not unhappy things.
The future makes happy, if you make it yourself.
No war; think about happy things."   -WouterSmitssm

Hard Light Productions:
"...this conversation is pointlessly confrontational."
 

Offline Kosh

  • A year behind what's funny
  • 210
Re: Need Excel help pronto!
Reply #5 on: July 02, 2006, 08:35:06 am
Yes, thank you.


Now I am finally on summer vacation!!!!!!!!!!!!!!!!!!!!!!!
"The reason for this is that the original Fortran got so convoluted and extensive (10's of millions of lines of code) that no-one can actually figure out how it works, there's a massive project going on to decode the original Fortran and write a more modern system, but until then, the UK communication network is actually relying heavily on 35 year old Fortran that nobody understands." - Flipside

Brain I/O error
Replace and press any key
Print
Pages: [1]   Go Up
« Previous Thread Next Thread »