2006-09-07 15:08:30 · 3 answers · asked by pikachuflatulates 5 in Computers & Internet ➔ Software
Start with your cursor in the cell where you want the result. Type = or + then click with your cursor on the cell of one of the factors, either quantity or price. Then type *. Then click on the other factor and press enter. That will build your formula for you.
You can copy the formula to other cells to multiply the same cells relative to the result. which means if you have a column of prices in Col A and a col of Quantities in Col B, you can make your formula in a cell of col C and then copy it to the other cells of Col C for every row of factors.
2006-09-11 09:15:16 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
= quantity*price
2006-09-07 22:12:04 · answer #2 · answered by heat 2 · 0⤊ 0⤋
lets say the qty is in C1
the price is in C2
the total is going to be =sum(C1*C2)
2006-09-07 22:11:10 · answer #3 · answered by Anonymous · 0⤊ 0⤋