Syntax error with minus formula in Apple Numbers

The minus operator is not sufficient for what you are trying ti do? For instance, the formula:

B1-A1

Would calculate the value in cell B1 minus the value in cell A1.

Patricefromvic wrote:

I am trying to deduct multiple cells from a single cell- no luck and keep getting a syntax error??? At my wits end

Hi Patrice,

Perhaps this will work for you:

Row 1 is a Header Row. (That may not be important).

Formula in B2 is B$1−A2

The $ symbol preserves the row.



Regards,

Ian.

Can you share what you are trying?

To post a screenshot shift-command-4, drag to select area, release, start new post here and use the mountains-and-moon 'Image insertion' icon beneath the compose window to insert the screenshot from the Desktop.

SG