Newbie question....about auto multiplications of colum data

[Just Wondering]

Hi , i'm a bit of a newbie to excel , but i have a list of data 50 lines ,
basically its has two colums , colum 1 is a price , colum 2 is the qty . but
i want to add a colum 3 that automatically multiplys for each line colum 1
prices by the colums 2 qty but i can't work out the formula ?

i thought it would go something along the lines of sum=(a*b=c) ???

what type of formula is this , so it will be easier for me to ultize in the
future for other spread sheets .

Thank you , any links to basic formulas for future ref would be great...

 

[JE McGimpsey]

Put this in C1:

=A1 * B1

and copy down. You can use the fill handle (lower right corner of the
cell).

Note that there's no need to use SUM(), and formulae can only return
values to the cells which contain them.

 

[Just Wondering]

Put this in C1:

=A1 * B1

and copy down. You can use the fill handle (lower right corner of the
cell).

Note that there's no need to use SUM(), and formulae can only return
values to the cells which contain them.

JE thank you very much for that , much much appericated , to take it one
step furthur , how would i set a colum to automatically be a multiplication
of colum 1+2 automatically , so if i add extra lines/data to both colums at
a later stage so that the sum is completed with out the need for fill ?

 

[Guest]

Hi

You can simply fill the column as far down as you wish. The cells will fill
with 0s though, as 0*0 is 0!
One way round this is to use an IF statement. Try this:
=IF(AND(A1<>0,B1<>0),A1*B1,"")
This check A1 and B1 for values and if they exist completes the calculation.

Andy.

 

[JE McGimpsey]

If you're adding data in sequential rows, check the Extend list formats
and formulas checkbox in Tools/Options/Edit.