If you appear to be having problems with a quote calculator formula, Microsoft Excel can be a useful tool to locate and fix the error.

Open Microsoft Excel and input the formula.

Please note, however, that some small changes will have to be made:

  • Replace the double squiggle brackets with single ordinary brackets: IF({{primary.home}}…) becomes IF(primary.home…)
  • In this instance, primary.home would need to be made a labelled cell. Click on the box with the current label (A1, M4, C12 etc.) to rename the label.

If you are unable to locate the error, please email us at [email protected]