 
Junior Member
Excel column multiplication how do i multiply each number in a column by a certain number with an easy function?
 
Member
Re: Excel column multiplication This is a QA forum  not a microsoft help group  see the online help within MS Excel for further information but the answer is something like: =sum(column A * n). Where column A = the column you want to be multiplied; And n is the number to multiply by.
Christ is this what this forum has become  if so I'm off!
Steve.
 
Senior Member
Re: Excel column multiplication I think it depends on what Cyric is using XL for. As a test tool I use it more often than teamtest or any other tool. He may be using it for the first time to emulate a calculation routine (I often do this myself) Sometimes I get stuck and, after briefly trying the help, I sometimes ask some people nearby if they know how to do something. Perhaps Cyric has tried the help to no avail and has run out of people to ask?
Otherwise I agree  this is a QA/Testing forum.
What is it you are using XL for Cyric?
 Softly, Softly catchee monkey... 
Senior Member
Re: Excel column multiplication <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Cyric wants to know: how do i multiply each number in a column by a certain number with an easy function? <HR></BLOCKQUOTE>
Hi Cyric,
The simplest formula is '=sum({cell ref}*n)'. You could put the multiplier in its own cell and then the formula would be
'=sum({cell ref}*{cell ref})'. That way you could always change the multiplier without having to fix every cell that contains the formula.
So are you using Excel as a test tool? And don't worry too much about Steve. I think he was wound a little toooooo tight

[This message has been edited by MelR (edited 07052001).] 
Senior Member
Re: Excel column multiplication Of course, the great thing about XL is that you can enter the formula in one row, for example:
type 9 in cell A1 and 8 in cell B1 then highlight cell C1 and type =A1*B1
Then highlight cell C1 and as many cells below it as you like then press CTRL+D (fill down)
The formula will automatically be correct for the rows concerned ie
C1 = A2*B2
C3 = A3*B3
At the other end of the scale, you can create a complex calculation emulator then copy and paste the whole thing to another part of the worksheet and the formulas will all still work.
that way you can create as many test cases as you need but only need to work out the mathce once when you create your first instance of the calculation emulator.
I might post my 'Quick and cheap good enough calculation testing tutorial later if I get tiem to proof read it'.
BTW, what is it you are trying to do with XL Cyric?
jules
 Softly, Softly catchee monkey... 
Senior Member
Re: Excel column multiplication P.S. Yes there are 2 glaring typing errors in the above posting. Sorry 'bout that but the principle remains sound.
 Softly, Softly catchee monkey... 
Senior Member
Re: Excel column multiplication P.P.S I've just realised that if I put a mistake in every post then post a correction soon after I will reach 'GURU' status twice as soon.
 Softly, Softly catchee monkey... 
Senior Member
Re: Excel column multiplication <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by Jules: P.P.S I've just realised that if I put a mistake in every post then post a correction soon after I will reach 'GURU' status twice as soon. <HR></BLOCKQUOTE>
Jules you are already a 'GURU' in our book! And yes, post your doc please!
 
Senior Member
Re: Excel column multiplication To get your "target" figure do the following:
Cell ref:
1 2 3

A  Num1 Num2 Formula
where Num1 = the number you want to be multiplied, Num2 = the figure you want to multiply Num 1 by and remain a constant and Formula should be:
=a1*a2
I can't beleive the request is THIS simple, so there must be something more to it...
 
Senior Member
Re: Excel column multiplication Although my diagram was not reproduced properly, I hope you understand.
If not Cyric, email me at davidc@hattonblue.com and I will mail you back with an attached example.

Posting Permissions
 You may not post new threads
 You may not post replies
 You may not post attachments
 You may not edit your posts

Forum Rules 