In a column of type formula, the function MULTIPLY () makes it possible to multiply the contents of several columns between them.
MULTIPLY (Column1, Column2, Column3)
MULTIPLY (Amount HT, VAT rate)
I have multiplied the contents of my Amount HT column with the contents of my VAT Rate column to have the amount of my VAT in the column of the same name.
MULTIPLY (Amount HT, 0.2)
I directly multiplied the contents of my column Amount HT with 0.2. This formula will be valid throughout the column.
This can be practical if you use a fixed rate, this allows you to delete the VAT Rate column of my example 1.
Please sign in to leave a comment.