Function SumInWordsVat

SUMINWORDSVAT() Description

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

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

Main Characteristics 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 for the calculated VAT amount: 0 - in numbers, 1 - in words. By default, the value "0" is used.

Example of Use

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

=SUMINWORDSVAT(Amount; VatRate; Format)

We will have the following result:

In this example, the following values are used:

• Amount: A2 - The number to be converted to text (10568,23).
• VatRate: B2 - VAT rate is 20% (20).
• Format: C2 - Option for displaying the result. 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.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).