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?
[pre]I shoulda bought robo's Excel book
when it was on special. [/pre]