CODEWITHSUNDEEP
macosms-wordformula
Lisa
Lisa

Reputation: 893

Formula code in Word 2015 [mac]

I'm currently making an invoice template in word, but I'm fighting with the formula code which is used.

Currently this is my table: Word 2015 table

But, the number of rows wil depend on the days which I've worked. Right now, I have to manually alter the code to edit the cell-references (d9, b10, c10) if I create more rows.

Is there an easier way to do this? To let the cell-reference automatically change or change the formula code in a way that naming the cell-references isn't needed?

Thanks in advance :)

Other images of what I have:

enter image description here

enter image description here

Upvotes: 1

Views: 914

Answers (1)

Cindy Meister
Cindy Meister

Reputation: 25663

If the Mac version behaves anything like the Window version then your best bet would be to BOOKMARK the cells. You can then use the bookmark names in the calculations instead of a cell reference.

For example, if you click at the left edge of the current D9, go to Insert/Bookmark and name it "Subtotal", then select cell B10 and insert a bookmark named "VAT" (both times without the double quotes ""!) you can use the bookmark names like this:

{ = { REF Subtotal } * { REF VAT } }

Note that it's sometimes possible to do this - { = Subtotal * VAT } - but that's not as certain as using a REF field.

Upvotes: 3

Related Questions