Excel Formula To Convert Number To Words In Indian Rupees

Juli 12, 2024 Posting Komentar

How to Convert Number to Word in Excel in Indian Rupees,Hindi YouTube from www.youtube.com

Introduction

Excel is a powerful tool that can help you perform various calculations and conversions. One of the most common requirements is to convert numbers to words, especially in the Indian currency system. In this article, we will discuss how to use an Excel formula to convert numbers to words in Indian rupees.

Understanding the Indian Currency System

Before we dive into the Excel formula, let's first understand the Indian currency system. The Indian rupee is divided into 100 paise. The denominations of Indian currency notes are 10, 20, 50, 100, 200, 500, and 2000.

Step 1: Separating the Rupee and Paise Values

To convert a number to words in Indian rupees, the first step is to separate the rupee and paise values. For example, if the number is 1234.56, then the rupee value is 1234, and the paise value is 56.

Step 2: Converting the Rupee Value to Words

To convert the rupee value to words, we can use the Excel formula =SpellNumber(A1). Here, A1 is the cell reference that contains the rupee value. This formula will convert the rupee value to words. For example, if the rupee value is 1234, the formula will return "One Thousand Two Hundred Thirty-Four."

Step 3: Converting the Paise Value to Words

To convert the paise value to words, we can use the Excel formula =IF(B1=0,""," AND ")+IF(LEN(B1)=1,"ZERO ","")+IF(INT(B1/10)=1, CHOOSE(B1, "TEN", "ELEVEN", "TWELVE", "THIRTEEN", "FOURTEEN", "FIFTEEN", "SIXTEEN", "SEVENTEEN", "EIGHTEEN", "NINETEEN"), CHOOSE(INT(B1/10), "","TEN ","TWENTY ","THIRTY ","FORTY ","FIFTY ","SIXTY ","SEVENTY ","EIGHTY ","NINETY ")+IF(MOD(B1,10)=0,"",CHOOSE(MOD(B1,10),"ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","EIGHT","NINE")+" PAISE")) Here, B1 is the cell reference that contains the paise value. This formula will convert the paise value to words. For example, if the paise value is 56, the formula will return "FIFTY-SIX PAISE."

Combining the Rupee and Paise Values

Once we have converted the rupee and paise values to words, we can combine them using the Excel formula =A1&" RUPEES "&B1. Here, A1 and B1 are the cell references that contain the rupee and paise values, respectively. This formula will combine the rupee and paise values in words. For example, if the number is 1234.56, the formula will return "ONE THOUSAND TWO HUNDRED THIRTY-FOUR RUPEES FIFTY-SIX PAISE."

Conclusion

In this article, we have discussed how to use an Excel formula to convert numbers to words in Indian rupees. By following the above steps, you can easily convert any number to words in the Indian currency system. This can be helpful in various scenarios, such as writing cheques, preparing invoices, or creating financial reports.

compass

Widget HTML #1