Quickly Perform Arithmetic

In Numbers, there isn't a direct way to perform arithmetic like subtraction directly in a cell without using the formula. You always need to start a formula with an equal sign and then enter your calculation. The usual process involves tapping or clicking on the cell, typing "=", and then the arithmetic operation you want to perform, such as "100 - x" where x is the value you want to subtract from the existing number.

However, you could make some modifications to your table to simplify the process.

For example, you can add two new columns(if permitted) after the Balance column, one for expenditure and another one for the calculation result.

If x=50, then you could type 50 in D2 and type "=C2-D2" in E2.

You can duplicate and reuse this entire row so next time, you only need to enter the value of x in column D, and the formula in column E will automatically calculate the result for you.

It is not a built-in feature but there is a shortcut (Shortcut App shortcut) for doing math in a cell or range of cells.

https://www.icloud.com/shortcuts/2e7186032e2244b7a96297d0a609fb32

Select the cell or range of cells

Run the Shortcut

It can do +-*/ and absolute value

Put the number in a separate cell and replace x with a reference to that cell.

(252805)