Options
- Title: Provide a title to the formula result by setting the title type and toggle “Title is visible?” to change the visibility on the calculator.
- Add tooltip: Toggle this option if you want to add a tooltip to the result.
- Description: Can add a description under the title. You can use markdown markups to format.
- Formula: To calculate the total value. Can use operators (+, -, / , *, ^), numbers (1, 10, 20.5, 1,5), and question and variable values (QA, QB, VA, VB) to build formulas. Besides, you can use IF, AND, OR, and 390 other Excel functions. Check out this article to learn more. Decimal numbers without a leading zero will not work (.76)
- Variables: Create variables if you want to use them in your formulas.
- Datasheets: Create datasheets to pick up values from a chart for your formula calculations and functions. You can copy and paste the spreadsheets you already have.
- Font Weight: Edit the style of the result (Light, normal or bold). Font Size: Adjust the size of the result.
- Decimals: Set up how many decimals you want to appear on the resulting number.
- Prefix: Symbol, number, or character you want to appear before the resulting number. (e.g. $)
- Postfix: Symbol, number, words, or character you want to appear after the resulting number. (e.g., per month)
- Is this question required?: Toggle if you want to make answering this number question mandatory.
- Show/Hide Logic: Toggle this if you want to control if this formula result is shown or hidden under certain circumstances.
- Visibility formula: If the result of the formula is TRUE or a number above 0. The question is visible. If the result is FALSE or 0, it’s hidden.
Usage in calculations
- Calculate a total value. Can use operators (+, -, / , *, ^), numbers (1, 10, 20.5, 1,5), and question and variable values (QA, QB, VA, VB) to build formulas. Besides, you can use IF, AND, OR, and 390 other Excel functions. Check out this article to learn more. Decimal numbers without a leading zero will not work (.76)