c语言a1到a10怎么表示,函数公式中A1到A10小于0的数怎么？

2008-08-11

怎把尾数是.00的数值提取出来怎

公式：=IF(LEN(A1)=LEN(TRUNC(A1)),A1,"")

公式：=IF(LEN(A1)=LEN(TRUNC(A1)),A1,"")&"、"&IF(LEN(A2)=LEN(TRUNC(A2)),A2,"")&"、"&IF(LEN(A3)=LEN(TRUNC(A3)),A3,"")&"、"&IF(LEN(A4)=LEN(TRUNC(A4)),A4,"")&"、"&IF(LEN(A5)=LEN(TRUNC(A5)),A5,"")&"、"&IF(LEN(A6)=LEN(TRUNC(A6)),A6,"")&"、"&IF(LEN(A7)=LEN(TRUNC(A7)),A7,"")&"、...全部

公式：=IF(LEN(A1)=LEN(TRUNC(A1)),A1,"")

公式：=IF(LEN(A1)=LEN(TRUNC(A1)),A1,"")&"、"&IF(LEN(A2)=LEN(TRUNC(A2)),A2,"")&"、"&IF(LEN(A3)=LEN(TRUNC(A3)),A3,"")&"、"&IF(LEN(A4)=LEN(TRUNC(A4)),A4,"")&"、"&IF(LEN(A5)=LEN(TRUNC(A5)),A5,"")&"、"&IF(LEN(A6)=LEN(TRUNC(A6)),A6,"")&"、"&IF(LEN(A7)=LEN(TRUNC(A7)),A7,"")&"、"&IF(LEN(A8)=LEN(TRUNC(A8)),A8,"")&"、"&IF(LEN(A9)=LEN(TRUNC(A9)),A9,"")&"、"&IF(LEN(A10)=LEN(TRUNC(A10)),A10,"")。

收起