Word Report Formula Reference Instruction

This document mainly introduces how to use formulas in Word reports.

Formula Use Requirements:

1. You do not need to nest formats when inserting formulas in Word. For example, the syntax for inserting a cell is {{=M3}}. If you want to sum this cell, the correct syntax is {{=SUM(M3)}}, rather than {{=SUM({{=M3}})}}.

2. You cannot reference hierarchical coordinates when inserting formulas in Word.

3. You need to use the nested IF function (if(condition,result1,(if(condition,result2,result3)))) in actual development scenarios with multiple conditions to be judged, rather than just two conditions to be judged in the if-else statement.

For example, three conditions (rising, falling, and fair) need to be judged during indicator analysis.

In this case, the formula is {{=if(N23<0,"falling "+format(N23*-1," #0.0%"),if(N23>0,"rising "+ format(N23," #0.0%"),"fair"))}}.

Requirements on Repeated Dynamic Text Widgets:

1. Parameters in widgets cannot be repeated. To repeat parameters, you need to add an equal sign (=). For example, if the custom parameter is {{=$a}}, you need to enter {{==$a}} to reference it in widgets.

2. The text to be repeated needs to be in a separate line, otherwise line break problems may occur.

3. You are advised to use indirect references in parameters of formulas in the text repeat widgets, rather than use cells directly (as they may cause semantic problems).

You can display relevant content in a Word report by referencing cells of the current template through formulas, as shown in the following table.

You cannot reference cells from other templates through formulas of Word, but you can reference cells from other sheets of the current template, as shown in the following table.

You can specify the repeat quantity in the dynamic text repeat widgets and reference the content to be repeated through formulas. The following table shows cases in which the cell content and dynamic text repeat widgets are used together.