11,677
edits
Changes
Importing a new version from external source
To create expressions in CSV files the following rules must be observed:
* The expression must begin with the character '''equal''' and character, be enclosed in '''parentheses'''and the columns enclosed in '''quotation''' marks. Examples: ''=("Price"/"Quantity")'', ''=(("Profit"*100)/"Price")''
* To reference other columns in the file, use the double-quoted column/header name
* It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression