您好、欢迎来到现金彩票网!
当前位置:秒速快3计划 > 数值到大写 >

EXCEL函数如何将数字转化成英文大写金额?

发布时间:2019-07-17 07:53 来源:未知 编辑:admin

  可选中1个或多个下面的关键词,搜索相关资料。也可直接点“搜索资料”搜索整个问题。

  知道合伙人互联网行家采纳数:1332获赞数:3650飞鸿世家库存推广团队领队人向TA提问展开全部

  =SAY US DOLLARS: &UPPER(TRIM(IF(VALUE(RIGHT(INT(A1/1000000000),3))=0,,LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),000),1)),{0,1,2,3,4,5,6,7,8,9;,one,two,three,four,five,six,seven,eight,nine})&IF(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),000),1)=0, , hundred )&IF(MID(TEXT(RIGHT(INT(A1/1000000000),3),000),2,1)=1,LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000000),3),000),2,2)),{10,11,12,13,14,15,16,17,18,19;ten,eleven,twelve,thirteen,fourteen,fiifteen,sixteen,seventeen,eighteen,nineteen}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000000),3),000),2,1)),{0,1,2,3,4,5,6,7,8,9;,,twenty,thirty,fourty,fifty,sixty,seventy,eighty,ninety}))&IF(MID(TEXT(RIGHT(INT(A1/1000000000),3),000),2,1)=1,,LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000000000),3),000),1)),{0,1,2,3,4,5,6,7,8,9;, one, two, three, four, five, six, seven, eight, nine}))& billion )&IF(VALUE(RIGHT(INT(A1/1000000),3))=0,,LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000),3),000),1)),{0,1,2,3,4,5,6,7,8,9;,one,two,three,four,five,six,seven,eight,nine})&IF(LEFT(TEXT(RIGHT(INT(A1/1000000),3),000),1)=0, , hundred )&IF(MID(TEXT(RIGHT(INT(A1/1000000),3),000),2,1)=1,LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000),3),000),2,2)),{10,11,12,13,14,15,16,17,18,19;ten,eleven,twelve,thirteen,fourteen,fiifteen,sixteen,seventeen,eighteen,nineteen}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000),3),000),2,1)),{0,1,2,3,4,5,6,7,8,9;,,twenty,thirty,fourty,fifty,sixty,seventy,eighty,ninety}))&IF(MID(TEXT(RIGHT(INT(A1/1000000),3),000),2,1)=1,,LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000000),3),000),1)),{0,1,2,3,4,5,6,7,8,9;, one, two, three, four, five, six, seven, eight, nine}))& million )&IF(VALUE(RIGHT(INT(A1/1000),3))=0,,LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000),3),000),1)),{0,1,2,3,4,5,6,7,8,9;,one,two,three,four,five,six,seven,eight,nine})&IF(LEFT(TEXT(RIGHT(INT(A1/1000),3),000),1)=0, , hundred )&IF(MID(TEXT(RIGHT(INT(A1/1000),3),000),2,1)=1,LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000),3),000),2,2)),{10,11,12,13,14,15,16,17,18,19;ten,eleven,twelve,thirteen,fourteen,fiifteen,sixteen,seventeen,eighteen,nineteen}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000),3),000),2,1)),{0,1,2,3,4,5,6,7,8,9;,,twenty,thirty,fourty,fifty,sixty,seventy,eighty,ninety}))&IF(MID(TEXT(RIGHT(INT(A1/1000),3),000),2,1)=1,,LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000),3),000),1)),{0,1,2,3,4,5,6,7,8,9;, one, two, three, four, five, six, seven, eight, nine}))& thousand )&LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1),3),000),1)),{0,1,2,3,4,5,6,7,8,9;,one,two,three,four,five,six,seven,eight,nine})&IF(LEFT(TEXT(RIGHT(INT(A1),3),000),1)=0, , hundred )&IF(MID(TEXT(RIGHT(INT(A1),3),000),2,1)=1,LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1),3),000),2,2)),{10,11,12,13,14,15,16,17,18,19;ten,eleven,twelve,thirteen,fourteen,fiifteen,sixteen,seventeen,eighteen,nineteen}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1),3),000),2,1)),{0,1,2,3,4,5,6,7,8,9;,,twenty,thirty,fourty,fifty,sixty,seventy,eighty,ninety}))&IF(MID(TEXT(RIGHT(INT(A1),3),000),2,1)=1,,LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1),3),000),1)),{0,1,2,3,4,5,6,7,8,9;, one, two, three, four, five, six, seven, eight, nine}))&IF(VALUE(RIGHT(TEXT(A1,0.00),2))=0,, AND CENTS &IF(VALUE(RIGHT(TEXT(A1,0.00),2))20,LOOKUP(VALUE(RIGHT(TEXT(A1,0.00),2)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19;,one,two,three,four,five,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fiifteen,sixteen,seventeen,eighteen,nineteen}),LOOKUP(VALUE(LEFT(RIGHT(TEXT(A1,0.00),2),1)),{2,3,4,5,6,7,8,9;twenty,thirty,fourty,fifty,sixty,seventy,eighty,ninety})& &LOOKUP(VALUE(RIGHT(TEXT(A1,0.00),1)),{0,1,2,3,4,5,6,7,8,9;,one,two,three,four,five,six,seven,eight,nine})))& ONLY))

http://hostgladjens.net/shuzhidaodaxie/486.html
锟斤拷锟斤拷锟斤拷QQ微锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷微锟斤拷
关于我们|联系我们|版权声明|网站地图|
Copyright © 2002-2019 现金彩票 版权所有