Calculate Values
'Calculate Values' is available in several templates.
This uses the information entered in different ranges to calculate the value of other ranges.
Examples of this are Sales Order Price based on the Customer, Product combination or 'VAT amount based on the VAT Code and Goods amount.
Where there is already a value in the cell - 'Calculate Values ' will not overwrite the existing values.