Simple Excel formula to convert number to words in Indian style.

[HMVYAS]

Example :
Rs 99,99,999.99
Rupees Ninety Nine Lakh Ninety Nine Thousand Nine Hundred Ninty Nine Paise Ninety Nine Only.

I need a simple formula to convert numbers up to Rs 99,99,999.99 into Words without any VBA, Module or Add in
which works in Excel Program in Android mobile also.

I have two Excel formulas. I can't attach the worksheet with this formulas. I have tried but failed. Sorry for that.
I have Office 365 excel program in computer and mobile.

One is to convert numbers up to 99,999.99 in Words.
Second one to convert numbers from 1,00,000 to 99,99,999.99 to Words.
Help me to have a single formula to convert numbers from 1 to 99,99,999.99 into Words.

(1) For the Numbers from 1 to 99,999.99 into words.
Please write the Number in the Excel Cell A3 and insert the given below formula in Excel Cell B3 and press Enter.

="Rupees "&TRIM(IF(OR(LEN(FLOOR(A3,1))=8,FLOOR(A3,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),1,1)+1,"",
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),2,1)+1,"ten ","eleven ","twelve ","thirteen ","fourteen ","fifteen ","sixteen ","seventeen ","eighteen ","nineteen "),"twenty ","thirty ","forty ","fifty ","sixty ","seventy ","eighty ","ninety "),IF(VALUE(MID(TEXT(INT(A3),REPT(0,7)),1,1))>1,
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),2,1)+1,""," one "," two "," three "," four "," five "," six "," seven "," eight "," nine "),IF(VALUE(MID(TEXT(INT(A3),REPT(0,7)),1,1))=0,
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),2,1)+1,"","one ","two ","three ","four ","five ","six ","seven ","eight ","nine "),"")),IF(VALUE(MID(TEXT(INT(A3),REPT(0,12)),7,1)), " lakh ",""),
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),3,1)+1,"",
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),4,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A3),REPT(0,7)),3,1))>1,
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),4,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"),IF(VALUE(MID(TEXT(INT(A3),REPT(0,7)),3,1))=0,
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),4,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A3),REPT(0,12)),7,3))," thousand ",""),
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),5,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),6,1)+1,"",
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),7,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A3),REPT(0,7)),6,1))>1,
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),7,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"),IF(VALUE(MID(TEXT(INT(A3),REPT(0,7)),6,1))=0,
CHOOSE(MID(TEXT(INT(A3),REPT(0,7)),7,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(A3,1)>1," ",""))&IF(ISERROR(FIND(".",A3,1))," and No Paise"," and "&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2))=1,
CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2),"ten","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety")&" Paise","")&CONCATENATE(
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),6,1)+1,"",
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen")&" Paise","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),6,1))>1,
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine")&" Paise",IF(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2)="01","one cent",IF(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),1)="0",
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A3,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,"","one","two","three","four","five","six","seven","eight","nine")&" Paise",""))))))))

(2) For the Numbers from 1 to 99,99,999.99 into words.
Please write the Number in the Excel Cell A7 and insert the given below formula in Excel Cell B7 and press Enter.

="Rupees "&TRIM(IF(OR(LEN(FLOOR(A7,1))=8,FLOOR(A7,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),1,1)+1,"",
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),2,1)+1,"ten ","eleven ","twelve ","thirteen ","fourteen ","fifteen ","sixteen ","seventeen ","eighteen ","nineteen "),"twenty ","thirty ","forty ","fifty ","sixty ","seventy ","eighty ","ninety "),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),1,1))>1,
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),2,1)+1,""," one "," two "," three "," four "," five "," six "," seven "," eight "," nine "),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),1,1))=0,
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),2,1)+1,"","one ","two ","three ","four ","five ","six ","seven ","eight ","nine "),"")),IF(VALUE(MID(TEXT(INT(A7),REPT(0,12)),7,1)), " lakh ",""),
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),3,1)+1,"",
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),4,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),3,1))>1,
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),4,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),3,1))=0,
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),4,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),5,1))," thousand ",""),
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),5,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),6,1)+1,"",
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),7,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),6,1))>1,
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),7,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"),IF(VALUE(MID(TEXT(INT(A7),REPT(0,7)),6,1))=0,
CHOOSE(MID(TEXT(INT(A7),REPT(0,7)),7,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(A7,1)>1," ",""))&IF(ISERROR(FIND(".",A7,1))," and No Paise"," and "&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2))=1,
CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2),"ten","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety")&" Paise","")&CONCATENATE(
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),6,1)+1,"",
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen")&" Paise","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),6,1))>1,
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine")&" Paise",IF(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2)="01","one cent",IF(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),1)="0",
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A7,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,"","one","two","three","four","five","six","seven","eight","nine")&" Paise",""))))))))

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[alansidman]

This is a common request in this forum. Scroll to the bottom of this thread to see other similar threads and solutions.

[HMVYAS]

EXCEL FORMULA FOR NUMBERS : 1 TO 99,999.99 in Indian method.
Write Amount / Number in Excel Cell A9 and insert the below mentioned formula (copy n paste) in Excel Cell B9 and press Enter. It works.

="Rupees "&TRIM(IF(OR(LEN(FLOOR(A9,1))=8,FLOOR(A9,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),1,1)+1,"",
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),2,1)+1,"ten ","eleven ","twelve ","thirteen ","fourteen ","fifteen ","sixteen ","seventeen ","eighteen ","nineteen "),"twenty ","thirty ","forty ","fifty ","sixty ","seventy ","eighty ","ninety "),IF(VALUE(MID(TEXT(INT(A9),REPT(0,7)),1,1))>1,
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),2,1)+1,""," one "," two "," three "," four "," five "," six "," seven "," eight "," nine "),IF(VALUE(MID(TEXT(INT(A9),REPT(0,7)),1,1))=0,
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),2,1)+1,"","one ","two ","three ","four ","five ","six ","seven ","eight ","nine "),"")),IF(VALUE(MID(TEXT(INT(A9),REPT(0,12)),7,1)), " lakh ",""),
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),3,1)+1,"",
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),4,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A9),REPT(0,7)),3,1))>1,
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),4,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"),IF(VALUE(MID(TEXT(INT(A9),REPT(0,7)),3,1))=0,
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),4,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(A9),REPT(0,12)),7,3))," thousand ",""),
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),5,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),6,1)+1,"",
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),7,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(A9),REPT(0,7)),6,1))>1,
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),7,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"),IF(VALUE(MID(TEXT(INT(A9),REPT(0,7)),6,1))=0,
CHOOSE(MID(TEXT(INT(A9),REPT(0,7)),7,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(A9,1)>1," ",""))&IF(ISERROR(FIND(".",A9,1))," and No Paise"," and "&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2))=1,
CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2),"ten","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety")&" Paise","")&CONCATENATE(
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),6,1)+1,"",
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen")&" Paise","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),6,1))>1,
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine")&" Paise",IF(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2)="01","one cent",IF(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),1)="0",
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(A9,".",REPT(" ",255)),255,200)),2)),REPT(0,7)),7,1)+1,"","one","two","three","four","five","six","seven","eight","nine")&" Paise",""))))))))

[HMVYAS]

Thanks for the support.
But I want to have a single formula to convert numbers from 1 to 99,99,999.99 in words e.g. Rs 99,99,999.99 in words "Rupees Ninety Nine Lakh Ninety Nine Thousand Nine Hundred Ninety Nine Paise Ninety Nine Only"
Anticipating a favorable help.