how to subract with Numbers
How do you setup a formula to subtract with Numbers. It provides "sum" but not "sub" for subtract...?
iMac, macOS Sierra (10.12.1), Apple Bluetooth Software Version: 4
Hi Sean,
Use the arithmetic operators: + - * / shown in rows 2-5.
Examples:
The formula below the table is the one in C2, shown as it appears in the Formula Editor.
Each operator should be entered as shown in column D. Numbers will immediately change the multiplication operator ( * ) to the multiplication sign ( × ), not to be confused with a lower case letter x, and will immediately change the division operator ( / ) to the division sign ( ÷ ).
Rows 6-9 contain similar formulas, using mathematical functions.
results are the same as the examples in the rows above, except for division. QUOTIENT always returns the quotient. which is always a whole number result, and ignores the remainder.
Note also, in row 7, the 3 is given a minus sign. that minus can be moved into the formula and placed here:
SUM(A7,-B7) to produce the same result with positive numbers in both columns.
Regards,
Barry