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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Just Wondering - 12 Dec 2005 23:40 GMT

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

Reply to this Message

JE McGimpsey - 12 Dec 2005 23:48 GMT

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.

> 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
[quoted text clipped - 7 lines]
>
> Thank you , any links to basic formulas for future ref would be great...

Reply to this Message