SumInWordsVat function for Excel

SUMINWORDSVAT() Description

The SUMINWORDSVAT() function converts any number into a written sum in Ukrainian with VAT (Value Added Tax).

Quite often, for accounting purposes, the cost of a trade transaction needs to be written down in words. For example, the amount 10,568.23 to express in words as "Десять тисяч п'ятсот шістдесят вісім гривень 23 копійки, у т.ч. ПДВ (20%) 1761.37 грн." , that is, the required amount in Ukrainian with VAT, but in Excel there is no standard function for such purposes.

Main Features of the SUMINWORDSVAT Function

Syntax:

=SUMINWORDSVAT(Amount; VatRate; [Format])

Parameters:

• Amount: The number to be converted to text.
• VatRate: VAT rate in percentage.
• [Format]: Optional. Type of display of the calculated VAT amount: 0 - in numbers, 1 - in words. The default value is "0".

Example Usage

The SUMINWORDSVAT() function is easy to use. You just need to enter any number into the formula, specify the VAT rate and the option to display the amount in words, and Excel automatically converts values to text:

=SUMINWORDSVAT(Amount; VatRate; Format)

We will have the following result:

This example uses the following values:

• Amount: A2 - The number to be converted to text (10568,23) .
• VatRate: B2 - The VAT rate is 20%. (20) .
• Format: C2 - Result display option. In this case, we will display the VAT amount in words (1) .

Download extension

You can use the function SUMINWORDSVAT() by installing the extension YLC Utilities .

Or its free version YouLibreCalc .

After that, this function will be available in all files that are opened in Excel .