Multiply cells

In numbers, like other spreadsheet programs, the asteristic may be used as the multiplication operator...

Addition operation: "+"

Subtraction operator: "-"

Multiplication: "*"

Division: "/"

to multiply a larger number of cells (in a column for instance) do the following:

e.g. lets say you have a number in columns A and B you want to multiply together where the result is in column C (and that the first row is a header row)

1) select the destination cell, cell C2

2) type the equal sign to begin entering a formula

3) single click cell A2, then type "*"

4) single click cell B2, then type return

5) select cell C2, copy

6) select cells C2 through the end of column C (or how ever many cells you want), paste

To select a large range of cells, single click the fist cell, then scroll to the end of the selection, then hold the **** key while single clicking the last cell

Numbers does have a function called PRODUCT() that takes two or more arguments. The following are equivalent:

=A1*B1

=product(A1,B1)

you could also type:

=A1*B1*F1

=product(A1,B1,F1)

Adding to Wayne's list:

Here is a list of the basic arithmetic functions, with an example of each.

Also included is the use of the subtraction operator in place of a "DiFFERENCE" function,

And DATEDIF function which returns the difference between two Date and Time values.

There is a full list of ALL functions supported in Numbers in the Function Browser.

To open the Browser, click on any unused cell in a Numbers table, then press = to open the Formula Editor at that cell, and the Function Browser in the right side bar.

In the Browser you can choose

to examine a number of related functions by choosing a category from the list on the left,

to scroll through the list on the right to go to a specific function, or

to enter the name of a specific function into the search box to go to the details about that specific function.

Each item on the list provides a description of that function and what it does,

an explanation of the syntax of that function, and

at least one example of how that function could be used in a Numbers document.

Regards,

Barry

NSAAH52 wrote:

I need to use multiply a lot and don't want to have to type it each time.

Yes, there is a wide variety of built-in options.

To multiple try this.

Select cells B2:C2 and drag the Product token into cell D2.

Then hover over cell D2 and drag the yellow dot down the column.

(With cell D2 selected you can also command-c, double-click the D column letter and command-v to paste into all body cells in the column).

The result will be something like this:

Keep in mind that when entering formulas in Numbers you usually don't have to do a lot of typing. For example, here you could also have selected cell D2, typed = to call up the formula editor, clicked in B2, typed * to multiply, then clicked in C2, and hit <enter>. For subtraction you would type - instead of * . For division you would type / . Numbers does most of the work for you.

If you have an internet connection then you may find that going in the menu to Help > Formulas & Functions Help is more convenient for viewing explanations and examples of how a particular function works than trying to read the same material within the constraints of the function browser in the right panel.

SG