Translations:Erweiterte Feldfunktionen/24/en

Example 1 ... Add 100 to the current price:

[math|price+100]

Example 2 ... Multiply the current price by 1.5; use a dot as the decimal separator:

[math|price*1.5|.]

Example 3 ... Add the values of the cells 'price' and 'shipping cost':

[math|price+shippingCost]

Example 4 ... Add/compute 4 values in one field: Import Price [price_list] + VAT [vat] + 20% surcharge + 5 (EUR) flat

[math|price_list*1.vat*1.2+5]

Example 5 ... value in the cell 'Import Price' [price_list] is e.g. 'VK25.25'. This however can not be used for calculations, so 'VK' must be deleted to change the value into a number. 'VK' is therefore replaced by "nothing", hence deleted. A simple replace within math does not work though, so a special one must be used !:

Schema: [math|column(+ calculation(optional))|decimal separator|search value(| substitution value (optional))]

 [math|price_list|.|VK]

Example 6 ... the value in the cell 'Import Price' [price_list] is e.g. '30.50 USD '. The numeric $ value is to be converted, the decimal separator is to be replaced by the comma and 'USD' by 'EUR':

Schema: [math|column+calculation|decimal separator|search value(|substitute value optional)]

 [math|price_list*0.9|,|USD|EUR]