IF(G24>0,IF(G24<0.1,TEXT(INT(G24*100)-INT(G24*10)*10,"[DBNum2]")&"分",IF(G24<1,IF(AND((INT(G24*10)-INT(G24)*10)=0,(INT(G24*100)-INT(G24*10)*10)<>0),"零","")&IF((INT(G24*10)-INT(G24)*10)=0,"",TEXT(INT(G24*10)-INT(G24)*10,"[DBNum2]")&"角")&IF((INT(G24*100)-INT(G24*10)*10)=0,"整",TEXT(INT(G24*100)-INT(G24*10)*10,"[DBNum2]")&"分"),TEXT(INT(G24),"[DBNum2]G/通用格式")&"元"&IF(AND((INT(G24*10)-INT(G24)*10)=0,(INT(G24*100)-INT(G24*10)*10)<>0),"零","")&IF((INT(G24*10)-INT(G24)*10)=0,"",TEXT(INT(G24*10)-INT(G24)*10,"[DBNum2]")&"角")&IF((INT(G24*100)-INT(G24*10)*10)=0,"整",TEXT(INT(G24*100)-INT(G24*10)*10,"[DBNum2]")&"分"))),0)
这代码是什么意思
请帮我解释一下这个的意思
你可能感兴趣的内容
大家正在搜