How to use circular formula reference in Zoho Writer

How to use circular formula reference in Zoho Writer

Overview

Zoho Writer allows you to handle circular references in formulas by setting limits on iterations or defining a threshold for convergence.  You can add formulas in paragraphs, tables, and merge and fillable templates in Zoho Writer.

Steps

  1. Right click the table cell where you wish to set up an iterative calculation.
  2. Click Setup Iterative Calculation in the menu.
  3. In the Iterative Calculation dialog that opens:
    1. Set the maximum number of recalculations and specify the convergence threshold.
Using formulas in Zoho Writer
List of formulas supported in Zoho Writer
How to format formula's output
How to refer formula's output across document