if函数怎么将小写数字计算出大写数字？

yi419367671

=IF("小写数据所在单元格位置"=0,"",CONCATENATE(IF(INT(ABS("小写数据所在单元格位置"))=0,"",TEXT(INT(ABS("小写数据所在单元格位置")),"[DBNum2]G/通用格式元")),IF(INT(MID(RIGHT(FIXED(ABS("小写数据所在单元格位置"),2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED("小写数据所在单元格位置",2,1),1),1,1))=0,"",IF(INT(ABS("小写数据所在单元格位置"))=0,"","零")),TEXT(INT(MID(RIGHT(FIXED("小写数据所在单元格位置",2,1),2),1,1)),"[DBNum2]G/通用格式角")),IF(INT(MID(RIGHT(FIXED("小写数据所在单元格位置",2,1),1),1,1))=0,"整",TEXT(INT(MID(RIGHT(FIXED("小写数据所在单元格位置",2,1),1),1,1)),"[DBNum2]G/通用格式分"))))

一人行

好！谢谢