Getting Started In This Chapter



Download 14.49 Mb.
Page69/209
Date conversion08.07.2018
Size14.49 Mb.
1   ...   65   66   67   68   69   70   71   72   ...   209

Inserting a Division Formula


This formula is only available for use where the outcome of the calculation is stored in a Marks (Integer), Marks (Decimal) or Comments aspect.

You can divide:



  • the value stored in one column by the value stored in another column.

  • the value stored in one column by a constant value.

  • a constant value by the value stored in a column.

  • Select Division from the Formula Type drop-down list.

  1. Select the first value (which is divided) and second column/constant value (which will divide by) (please see Selecting Column/Constant Values on page 142).

NOTE: When reference is made to an empty cell in a marksheet, a blank outcome is generated. Similarly, if the process involves dividing by zero, a blank outcome is generated.
      1. Inserting a Difference Formula


This formula is only available for use where the outcome of the calculation is stored in a Marks (Integer), Marks (Decimal) or Comments aspect.

You can subtract:



  • the value stored in a column from the value stored in another column.

  • the value stored in a column from a constant value.

  • a constant value from the value stored in a column.

  1. Select Difference from the Formula Type drop-down list.

  2. Select the first column/constant value (to be subtracted from) and the second column/constant value (to subtract) (please see Selecting Column/Constant Values on page 142).

NOTE: When reference is made to an empty cell in the marksheet, a blank outcome is generated.
      1. Inserting a Sum Formula


This formula is only available for use where the outcome of the calculation is stored in a Marks (Integer), Marks (Decimal) or Comments aspect.

This formula will total the values found in the columns you select.





  1. Select Sum from the Formula Type drop-down list.

  2. Choose a selection of the columns to be totalled (please see Choosing a Selection of Columns on page 143).

NOTE: Any blank cell included in the calculation is treated as ‘0’. Where reference is made to cells displaying ages, the contents of the cell are converted to months before being included in the calculation. Where a reference is made to a cell displaying a grade, the value of the displayed grade is used.
1   ...   65   66   67   68   69   70   71   72   ...   209


The database is protected by copyright ©dentisty.org 2016
send message

    Main page