TOP

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:

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:

Example of using the SUMINWORDSVAT() function
Example of using the SUMINWORDSVAT() function

In this example, the following values are used:

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).


This function is also available in the following extensions: YLC LightYLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel