How do you type a multiply sign into a formula in Numbers 3.6?

Question

How do you type a multiply sign into a formula in Numbers 3.6?

How do you insert a times/multiply sign into a formula? The letter X doesn't work. I found a reference that says use an asterisk (shift/8), but that doesn't work, either.

Thanks.

Posted on Jan 1, 2016 10:16 PM

Reply

Answer 1

Best reply

FishingAddict

Level 4

2,533 points

Jan 1, 2016 10:34 PM in response to David Blomstrom

Just use the actual asterisk character by typing shift-8.

Reply

Answer 2

Yellowbox

Level 7

20,389 points

Jan 1, 2016 10:31 PM in response to David Blomstrom

Hi David,

Type = to start a formula.

To multiply, type an asterisk *. Numbers changes that to x

To divide, type a forward slash /. Numbers changes that to

÷

If you type =B2*2/4

Numbers changes that to =B2×2÷4

(With a small font size, the divide sign looks like a plus sign).

Also, no need to type the cell reference; just click on the source cell (B2 in this example).

Regards,

Ian.

Reply