The VND function in Excel has a #NAME error and how to fix it

Are you having trouble working because the VND function in Excel has a #NAME error? Refer to the solution shared by TipsMake in the article!

When working with Excel, especially those who are new to learning and getting used to it, they will certainly often encounter some errors and not know how to solve them. The VND function in Excel with #NAME error is also one of the common confusing cases and many people do not know how to fix it. Don't worry, TipsMake will immediately help you solve it in the simplest way.

The VND function in Excel has a #NAME error and how to fix it Picture 1

Share how to fix the VND function in Excel with #NAME error

The #NAME error often appears when users enter a function that Excel does not recognize or does not exist. As for the VND function, this is a function that is not built into Excel for older versions. It's just an Add-ins (extension) that users install into Excel to use! Therefore, if the vnd function has a name error, there is a high possibility that you have not installed the Add ins VND function extension into Excel. How to fix errors in detail below.

Detailed instructions on how to fix VND function errors in Excel

This is a way to convert numbers into words, with a little more options than just using the VND function.

1. Step 1 : First, you need to install the Add-Ins file to your device HERE .
2. Step 2 : After installation is complete, open the Excel application on your computer > Click the File tab > Select Options (for older versions, More > Options).

The VND function in Excel has a #NAME error and how to fix it Picture 3

1. Step 3 : In the next interface, click Add-Ins in the left column > Then, scroll down to the Manage line > Select Go…

The VND function in Excel has a #NAME error and how to fix it Picture 5

1. Step 4 : When the Add-Ins window displays> Click on Browse .

The VND function in Excel has a #NAME error and how to fix it Picture 6

1. Step 5 : Select the Add-Ins file you downloaded in step 1 > Click OK .
2. Step 6 : Go back to the Add-Ins window > Check the Univni name you just added and click OK.

The VND function in Excel has a #NAME error and how to fix it Picture 8

So you have completed the process of adding the Add-Ins file. If you want to change numbers to words, users can use the following functions:

=UNI(Amount_Amount) in case you use Unicode font.

=VNI(Amount_Amount) in case you use the font VNI.

Note:

1. In case you need it faster, just use the =VND function to convert numbers to words. You do not need to download the above file, just download the Excel file =VND HERE . Then, you do the same from step 2 to step 6.

The VND function in Excel has a #NAME error and how to fix it Picture 10

1. After completing the Add-Ins process, to change the number to money, you just need to enter the function =VND(Number_to_change) .

The VND function in Excel has a #NAME error and how to fix it Picture 12

Some other causes and solutions

1. After adding Add-Ins but still unable to use the function, it may be because you entered the wrong syntax. Specifically, the VND function needs to be capitalized and the argument needs to be placed in parentheses. For example =VND(A1) . In which, A1 is the cell address containing the integer value you need to change.
2. The Excel version you are using is outdated and inappropriate, which is why the error occurred. Please update to the latest version of Excel if necessary and check to see if you still encounter this error or not!

Above are the solutions when the VND Function in Excel has the #NAME error. Wishing you guys success in overcoming it.

Jessica Tanner

Update 12 December 2023