Forum Discussion
Convert Number to Words LAMBDA (Very Large Numbers)
I created this LAMBDA Function "Number_To_Words" in order to convert Numbers to Words (eg. 2813 can be written as Two Thousand Eight Hundred Thirteen in words) First Parameter of the function is ...
SergeiBaklan My goal was actually two fold for both Indian as well as International Number System. Both are very different in terms of place value of numbers. I first made for Indian and then adapted as per International System (With few addons, Some steps and Lookup Tables were common).
I have now downloaded your Lambda function. Congratulations, there is nothing short in terms of ambition in that function! I did try
= MAP(target, format, Indian.Number_To_Words)where 'format' is a range containing {1;0;1} but it only returned the first number.
[Added. Only the first number had no decimal digits, so MAP works OK with your function]
The "Indian" prefix came about because I specified a Name space; I have never done that before.
The only thing I wondered about was whether it is necessary to be able to switch between international and local practice for reporting numbers? Wouldn't two functions have done the job as well and permitted some further optimisation of the individual code?
- Thanks a lot for the praise. Actually I originally made the function as per Indian Number System but then thought of adding more flexibility of choosing between the two systems as many steps were common in them.
I agree with PeterBartholomew1 , it's better to separate functions for each language. If only your are not going to generalize it and include few dozens of languages.
That's normal practice. For example, we don't have FILL() function with parameters Up and Down, we have FillUp() and FillDown().
- Yes you are right Sir. Separating gives clarity as well 👍
