1. ## Excel column multiplication

how do i multiply each number in a column by a certain number with an easy function?

------------------

2. ## 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.

------------------

3. ## 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?

------------------

4. ## 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 07-05-2001).]

5. ## 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

------------------

6. ## 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.

------------------

7. ## 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.

------------------

8. ## 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>

------------------

9. ## 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...

------------------

10. ## 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.

------------------

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.