Testing a formula

If you have not already done so, open the Formula window and display the formula you want to test. How?

To test a formula:

  1. Click [Test].

  2. Enter values for each of the variables listed in the Test Formula window. Use values that will produce a result you can verify rather than random values.

    Click [Total] or press Enter from the last variable to display the result.

  3. Check the result displayed in the Total text box.

    4. You can use the Sage Estimating (SQL) calculator to check the formula result. How?

  4. When you finish testing the formula, click [Close] to return to the Formula window.
  5. Did your formula calculate properly?
    • Yes. Congratulations, you're done!
    • No. Change the formula as needed, and then test it again.