how do I multiply contents of 2 columns in numbers ?
numbers-OTHER, Mac OS X (10.7.3)
Assuming you mean multiply a cell in column A to a cell in column B of the same row:
C2=A2*B2
select C2 and fill down (by grabbing , click and hold, the little control circle at the bottom right of the selected cell), then drag straight down
Thanks Wayne,
That is a big help, it allows me to activate one cell but struggling with setting up the column to do it automatically without me doing for each cell
Regards
Martin
assuming you placed the formula in cell C2... select C2 and fill down (by grabbing , click and hold, the little control circle at the bottom right of the selected cell), then drag straight down
I tried that massive document and could not find any reference to multification or multiplying numbers, for a mac software it is not the usual ease of use
That is the solution. Thank you very much.
I was being impatient and should have figured this out on my own. It's probably me but I find Apple software often times to be the least intuitive.
how do I multiply contents of 2 columns ?
