金额中文式大写公式设计

p27371245

QUOTE:

以下是引用离嗔居士在2007-11-22 15:11:02的发言：
=IF((INT(A1111*10)-INT(A1111)*10)=0,TEXT(INT(A1111),"[DBNum2]G/通用格式")&"元"&IF((INT(A1111*100)-INT((A1111)*10)*10)=0,"整","零"&TEXT(INT(A1111*100)-INT(A1111*10)*10,"[DBNum2]G/通用格式")&"分"),TEXT(INT(A1111),"[DBNum2]G/通用格式")&"元"&IF((INT(A1111*100)-INT((A1111)*10)*10)=0,TEXT((INT(A1111*10)-INT(A1111)*10),"[DBNum2]G/通用格式")&"角整",TEXT((INT(A1111*10)-INT(A1111)*10),"[DBNum2]G/通用格式")&"角"&TEXT(INT(A1111*100)-INT(A1111*10)*10,"[DBNum2]G/通用格式")&"分"))

金额的数字在哪个单元格就将“A1111”换成哪个单元格！

=TEXT(INT(A8),"[DBNum2]G/通用格式")&"元"&IF((INT(A8*10)-INT(A8)*10)=0,"",TEXT(INT(A8*10)-INT(A8)*10,"[DBNum2]G/通用格式")&"角")&IF((INT(A8*100)-INT(A8*10)*10)=0,"整",TEXT(INT(A8*100)-INT(A8*10)*10,"[DBNum2]G/通用格式")&"分")

也以这样写