Formulas

Get started with formulas

How does a formula work?

A formula can have the following components:

  • numbers: (1, 12, 1.5, 20.5)
  • operators: (+, -, *, /, ^)
  • question values: (QA, QB, QC)
  • variable values: (VA, VB, VC)

While numbers and operators are self-explanatory, question values are user-inputted responses based on values assigned in calculator questions. For example, when asking about "width" or "finish", you can assign values to these inputs and use them to calculate outcomes like price or savings.

An example of a simple formula is this:

FS
QA * 100 + 100

In this formula, we multiply the value of Question A by 100 and add 100. When a user changes the value of QA (for example, by sliding the range slider), the value of the formula changes automatically.

Common issues

Your formula syntax must follow certain 'rules' to successfully calculate outcomes. The following scenarios will generate errors in your formula:

  • Numbers with comma decimals (e.g 1,1 or 1,000.54) will NOT work.
  • Numbers with decimals without a leading zero (e.g .76) will NOT work.
  • Using = before a formula causes the formula to throw an ERROR.
  • Dividing by 0 causes the formula to throw an ERROR.

Using Functions

Functions can make your formulas even more powerful. A function is an expression that calculates a value. A function can have input arguments, and it returns an output. The IF function is a perfect example of a function that can be used inside a formula:

IF(QA > 50, QA * 2, 0)
With ConvertCalculator you can use all common functions that you might already know from your favorite spreadsheet program. See the functions page for a full list of supported functions.

Related articles

Learn more about formulas in one of the following articles