That's interesting to compare withPeterBartholomew1formula suggested couple of years agohttps://techcommunity.microsoft.com/t5/excel-blog/announcing-let/ba-p/1233572 =LET(Denom,{" Trillion ";" Billion ";" Million ";" Thousand ";" Dollars ";" Cents"},Nums,{"","One","Two","Three","F...
TextDollarAmountλ=LAMBDA(target,LET(Denom,{" Million, ";" Thousand ";" Dollars ";" Cents"},Nums,{"","One","Two","Three","Four","Five","Six","Seven","Eight"," Nine"},Teens,{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen...
TextDollarAmountλ=LAMBDA(target,LET(Denom,{" Million, ";" Thousand ";" Dollars ";" Cents"},Nums,{"","One","Two","Three","Four","Five","Six","Seven","Eight"," Nine"},Teens,{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen...
TextDollarAmountλ=LAMBDA(target,LET(Denom,{" Million, ";" Thousand ";" Dollars ";" Cents"},Nums,{"","One","Two","Three","Four","Five","Six","Seven","Eight"," Nine"},Teens,{"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen...
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. ...
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. ...