String search
Word search

Test a formula

Introduction

You can create and configure new formulas in the Formula manager. You must test each new formula for correctness.

About this task

A new formula is created in column Z. The new formula is based on two [Job ticket items]: [Copies] and [Cover]. In this procedure, the new formula is tested for correctness.

Procedure

  1. Check that the new pricing column uses the values from column [Amount:].
    1. Click cell Z78.
    2. Click "Trace Precedents" from the Excel menu.

      The usage of the "Trace Precedents" function is described in the Microsoft Excel help file.

    3. Check that the value from column [Amount:] is used for [Copies].
    1. Click cell Z141.
    2. Click "Trace Precedents" from the Excel menu.
    3. Check that the values from column [Amount:] are used for [Cover].
  2. Check that the result table uses the correct values for all job ticket items from the concerning column in the job ticket table.
    1. Click cell Z13.
    2. Click "Trace Precedents" from the Excel menu.
    3. Check that the result table uses the correct value for [Copies].
    1. Click cell Z26.
    2. Click "Trace Precedents" from the Excel menu.
    3. Check that the result table uses the correct value for [Cover].
  3. Check that the calculation uses the correct values from the result table.
    1. Click cell Z7.
    2. Click "Trace Precedents" from the Excel menu.
    3. Check that the calculation uses the correct values for [Copies] and [Cover].
  4. Check that the formula uses the correct calculation.
    1. Click cell Z3.
    2. Click "Trace Precedents" from the Excel menu.
    3. Check that the formula uses the correct calculation.
Parent topic:
Working with the formulas
Privacy Terms of use Cookie information