Billy T

01-04-2004, 05:23 PM

Hi Team

I have two files, each of four columns, with 40 and 50 numbers respectively in each column representing four channels of electronic data. I need to multiply every number by 3 (or perhaps 3.x, I'm not 100 % sure yet). That is 360 separate calculations and 360 opportunities to make a mistake entering the new value.

It figures that Excel can do this for me, but I am an absolute novice at any form of formula use in Excel. I can do it in rows if that is easier as there would only be four numbers in each row, however I don't care how I achieve the end result as long as I don't spend all night and half of tomorrow doing it.

Can anybody provide me with a step 1-2-3-4 etc process that an Excel tyro can follow without having a serious brain implosion?

Cheers

Billy 8-{)

I shoulda bought robo's Excel book

when it was on special. :(

I have two files, each of four columns, with 40 and 50 numbers respectively in each column representing four channels of electronic data. I need to multiply every number by 3 (or perhaps 3.x, I'm not 100 % sure yet). That is 360 separate calculations and 360 opportunities to make a mistake entering the new value.

It figures that Excel can do this for me, but I am an absolute novice at any form of formula use in Excel. I can do it in rows if that is easier as there would only be four numbers in each row, however I don't care how I achieve the end result as long as I don't spend all night and half of tomorrow doing it.

Can anybody provide me with a step 1-2-3-4 etc process that an Excel tyro can follow without having a serious brain implosion?

Cheers

Billy 8-{)

I shoulda bought robo's Excel book

when it was on special. :(