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
=SUMINWORDSVAT(Amount; VatRate; [Format])
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:
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).