有一个公式(用于将数字数量转换为单词数量(，该公式在早期版本的Google工作表中运行良好。在新工作表中，它不再工作并给出以下错误：
错误：函数 SELECT 参数 1 值为 0。有效值介于 1 和 19 之间(含 1 和 19(。
公式有点大和复杂(多个if函数( - 请参阅下面的链接，查看公式 - (在单元格B2中( -
https://docs.google.com/spreadsheets/d/1XdcKbxKvIOSFK37zwULZns6giE9ounHPS5iHrRFkvIk/edit#gid=882895877
=arrayFormula(concatenate(if(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0}))<100,"",choose(int(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0}))/100)," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine") & " Hundred") & if(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100)<>0,if(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0}))>100," and",if(A2>power(10,{11,9,7,5,3}),choose({1,2,3,4,5},"","","",""," and"),"")),"") & if(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100)=0,"",if(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100)<20,choose(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100)," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"),choose(int(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100)/10),""," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") & if(mod(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100),10)=0,""," " & choose(mod(mod(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0})),100),10),"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")))) & if(trunc(mod(A2,power(10,{11,9,7,5,3}))/power(10,{9,7,5,3,0}))=0,"",choose({1,2,3,4,5}," Arab"," Crore"," Lakh"," Thousand","")))) & " only"
根据 SELECT 函数文档 如果索引为零、负数或大于提供的选项数，则返回 #VALUE！ 错误。
话虽如此，我认为您只需计算数字即可完成此任务，然后通过使用一系列 =RIGHT(( 函数隔离您的数字来选择每个数字的单词版本。