formulas in numbers

Bless My Dear Aunt Sally can probably help you here.

B MD AS is a mnemonic phrase to help kids learning about 'order of operations in Math.

Translated to math speak it says:

Start with what's in brackets (parentheses)

Do all the Multiplication and Division

Then do the Addition and Subtraction.

Within each level, work from left to right.

" I want to subtract one cell from another and then divide that amount by another cell"

To do that, you'll need to enclose the subtraction inBrackets, so it gets done first.

formula: (A-B)/C

Replace A and B with the addresses of the cells containing the values to be subtracted. Wrap that part in parentheses.

Replace C with the address of the cell that will contain the divisor.

Numbers will replace the division operator ( / ) with the division sign ( ÷ ).

Regards,

Barry

cell B2 has the number 5 in it

cell B3 has the number 6 in it

cell B4 has the number 7 in it

cell B5 has the formula =(B3-B2)/B4

Numbers will substitute the math symbols with ones it thinks are more appealing and it will look like this:

(B3−B2)÷B4