Formula tool

Formula tool button Version 1.0.5

The formula tool calculates values according to a mathematical equation defined by the user, making it one of the most applicable and versatile tools for building a financial model. Unlike Excel or Sheets, this tool utilizes specific cells as defined by the sheet, row/column name, and year to prevent cell reference errors.

Formula tool interface Version 1.0.6

The formula tool solves the equation entered in its Formula box. The tool can be applied to rows or custom columns. Equations are entered in the formula box using tags.

See Applying tools for an explanation of how tools are used in Parfera.