Function spanning multiple rows and columns

[robzima]

Hey guys, just a quick question that I haven't been able to pinpoint a solution to yet.

I'm running inventory with a quantity, the at cost price, and the selling price. I'd like to take the quantity and multiply it by the cost price to produce how much money this is worth in inventory cost, and I'd like another function to multiply the quantity times the selling price to tell me how much money I'll make, then another function for the difference of the two to see how much profit I'll make.

The problem isn't doing those things above, but I need to do this to about 5000 rows of material and don't want to go back 5000 times to change the numbers in each of the functions. Is there an easy way to create a column consisting of a function between two entries in the corresponding row without having to go back and change the numbers 5000 times?

[NBVC]

If you use a formula like =A1*B1 where A1 contains a cost and B1 a quantity, then you can just copy that formula down the rows and it will adjust to =A2*B2, =A3*B3 and so on.

To copy down, select the cell of the first formula, click, hold and drag down the little black square at bottom right corner of the cell.

Is that what you mean?

[arthurbr]

Multiply values in A1 and B1 by entering =b1*a1 in the destination cell then pull down the formula s needed, the cell ref will adapt