农行支票打印

￥5000000001132017零壹壹拾叁材料款江苏国恒建设发展有限公司贰零零叁¥5,000,000.00材料款江苏国恒建设发展有限公司伍佰万元整目标值：5188.1各部分转换值整数部分伍仟壹佰捌拾捌元角位壹角分位零分角分位壹角零分判断条件是否为零FALSE是否只有整数部分FALSE是否没有整数部分FALSE是否只有角TRUE是否只有分FALSE转换值：分三次转换元位角分位转换值伍仟壹佰捌拾捌元壹角整伍仟壹佰捌拾捌元壹角整伍仟壹佰捌拾捌元壹角整伍仟壹佰捌拾捌元壹角整伍仟壹佰捌拾捌元壹角整目标值：5188.15各部分转换值整数部分角位分位角分位判断条件是否为零是否只有整数部分是否没有整数部分是否只有角是否只有分转换值：分三次转换元位角分位=IF(TRUNC(C2,2)=0,0,IF(TRUNC(C2,2)=INT(C2),TEXT(TRUNC(C2),[DBNUM2])&元整,IF(TRUNC(C2)=0,,TEXT(TRUNC(C2),[DBNUM2])&元)))=IF(OR(B21=0,TRUNC(C2,2)=INT(C2)),0,IF(RIGHT(TEXT(TRUNC(C2,2),0.00),1)=0,TEXT(MID(C2,LEN(TEXT(TRUNC(C2,2),0.00))-1,1),[DBNUM2])&角整,IF(MID(C2,LEN(TEXT(TRUNC(C2,2),0.00))-1,1)=0,TEXT(RIGHT(TEXT(TRUNC(C2,2),0.00),1),[DBNUM2])&分,TEXT(MID(C2,LEN(TEXT(TRUNC(C2,2),0.00))-1,1),[DBNUM2])&角&TEXT(RIGHT(TEXT(TRUNC(C2,2),0.00),1),[DBNUM2])&分)))=IF(D11,数值为零,IF(D12,D5&整,IF(D13,,D5)))=IF(D12,,IF(D14,D6,IF(D15,IF(D13,D7,零&D7),D8)))=IF(D11,数值为零,IF(D12,D5&整,IF(D13,IF(D14,D6&整,IF(D15,D7,D8)),IF(D14,D5&D6&整,IF(D15,D5&零&D7,D5&D8)))))=TEXT(TRUNC(C2),[DBNUM2])&元=TEXT(MID(C2,LEN(TEXT(TRUNC(C2,2),0.00))-1,1),[DBNUM2])&角=TEXT(RIGHT(TEXT(TRUNC(C2,2),0.00),1),[DBNUM2])&分=D6&D7=IF(TRUNC(C2,2)=0,TRUE,FALSE)=IF(TRUNC(C2,2)=TRUNC(C2),TRUE,FALSE)=IF(TRUNC(C2)=0,TRUE,FALSE)=IF(RIGHT(TEXT(TRUNC(C2,2),0.00),1)=0,TRUE,FALSE)=IF(MID(C2,LEN(TEXT(TRUNC(C2,2),0.00))-1,1)=0,TRUE,FALSE)转换值=IF(AND(OR(B21=0,B21=),C21=),数值为零,IF(C21=0,B21,IF(MID(C2,LEN(TEXT(TRUNC(C2,2),0.00))-1,1)=0,B21&零&C21,B21&C21)))=IF(D11,数值为零,B22&C22)=IF(D11,数值为零,IF(D12,D5&整,IF(D13,IF(D14,D6&整,IF(D15,D7,D8)),IF(D14,D5&D6&整,IF(D15,D5&零&D7,D5&D8)))))