Word 2015中的公式代码[mac] [英] 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:

但是，行数取决于我工作的天数.现在，如果我创建更多行，则必须手动更改代码以编辑单元格引用(d9，b10，c10).

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?

先谢谢您了:)

我所拥有的其他图像:

推荐答案

如果Mac版本的行为类似于Window版本，那么最好的选择就是对单元格进行书签.然后，您可以在计算中使用书签名称，而不是单元格引用.

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.

例如，如果单击当前D9的左边缘，请转到插入/书签"并将其命名为小计"，然后选择单元格B10并插入一个名为"VAT"的书签(两次不带双引号"！)，您可以使用如下书签名称:

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 } }

请注意，有时可以执行此操作-{=小计*增值税}-但这并不像使用REF字段那样确定.

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

这篇关于Word 2015中的公式代码[mac]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！