convert numer into text using above if formula

Question

convert numer into text using below if formula .There is an error in above formula so corrct the formula or suggest another formula using if

 

=PROPER(TRIM(IF(C9>=1,"Rupees
","")&IF(INT(C9/10^7)>19,INDEX(T,INT(C9/10^8)+1)&INDEX(O,MOD(INT(C9/10^7),10
)+1),INDEX(O,INT(C9/10^7)+1))&IF(INT(C9/10^7)>0," crore ","
")&IF(INT(MOD(C9,10^7)/10^5)>19,INDEX(T,INT(MOD(C9,10^7)/10^6)+1)&INDEX(O,MO
D(INT(MOD(C9,10^7)/10^5),10)+1),INDEX(O,INT(MOD(C9,10^7)/10^5)+1))&IF(INT(MO
D(C9,10^7)/10^5)>0," lakh ","
")&IF(INT(MOD(C9,10^5)/10^3)>19,INDEX(T,INT(MOD(C9,10^5)/10^4)+1)&INDEX(O,MO
D(INT(MOD(C9,10^5)/10^3),10)+1),INDEX(O,INT(MOD(C9,10^5)/10^3)+1))&IF(INT(MO
D(C9,10^5)/10^3)>0," thousand ","
")&IF(INT(MOD(C9,10^3)/100)>19,INDEX(T,INT(MOD(C9,10^3)/10^3+1))&INDEX(O,INT
(MOD(C9,10^3)/100)+1),INDEX(O,INT(MOD(C9,10^3)/100)+1))&IF(INT(MOD(C9,10^3)/
100)>0," hundred ","
")&IF(MOD(C9,100)>19,INDEX(T,INT(MOD(C9,100)/10)+1)&INDEX(O,MOD(C9,10)+1),IN
DEX(O,MOD(C9,100)+1))&IF(MOD(C9,1)>0,IF(C9>=1," and ","")&" Paise
","")&IF(MOD(C9,1)>0.19,INDEX(T,INT(MOD(C9,1)*10)+1)&INDEX(O,MOD(MOD(C9,1)*1
00,10)+1),INDEX(O,INT(MOD(C9,1)*100)+1))))&IF(C9>0," only","")

Answer 1

The Indian system of representing large numbers is different from the Western system of using commas (or spaces) to separate digits into groups of three. The Indian system is still based on the decimal numbering system, like the Western system, but divides the smallest group into 3 digits while larger groups are decimal numbers in pairs. The given algorithm attempts to convert currency numbers in terms of rupees, crores, lakhs and paises.

One lakh is written 1,00,000. (Western 100,000 or 10⁵).

One crore is written 1,00,00,000 (Western 10,000,000 or 10⁷).

One paise or paisa is 0.01 rupee (Western).

The algorithm inspects the size of a number and performs an analysis to express the number in terms of crores, lakhs and rupees.

EXAMPLE

987654321.98 would probably be written 98,76,54,321.09.

There are other terms for higher powers of ten, but the algorithm doesn't deal with these. However, the grouping into pairs of digits continues.

Ninety-eight crore, seventy-six lakh, fifty-four thousand three hundred and twenty-one rupees, nine paise. (Western equivalent ₹987,654,321.09, where ₹ means rupees.)