多此一举,只为自己。
方法01: | 字符数: | 公式一: | 字符数: | 公式二: | 方法02: | 9 | =INT(A2) | 14 | =FLOOR(A2,10) | 方法03: | 11 | =TRUNC(A2) | 14
| =TRUNC(A2,-1)
| 方法04: | 13 | =FLOOR(A2,1) | 15 | =A2-MOD(A2,10) | 方法05: | 14 | =A2-MOD(A2,1) | 15 | =INT(A2*0.1)&0 | 方法06: | 14 | =MROUND(A2,1) | 15 | =INT(A2/10)*10 | 方法07: | 16 | =QUOTIENT(A2,1) | 17 | =TRUNC(A2/10)*10 | 方法08: | 17 | =ROUNDDOWN(A2,0) | 18 | =ROUNDDOWN(A2,-1) | 方法09: | 19 | =TEXT(A2,"0!0")/10 | 19 | =CEILING(A2,10)-10 | 方法10: | 19 | =TEXT(INT(A2),"#") | 19 | =FLOOR(A2/10,1)*10 | 方法11: | 19 | =TEXT(INT(A2),"0") | 22
| =FLOOR.PRECISE(A2,10)
| 方法12: | 24 | =TEXT(INT(A2),"G/通用格式") | 23 | =ROUNDDOWN(A2/10,0)*10 | 方法13: | 25 | =LEFT(A2,FIND(".",A2)-1) | 24 | =INT(ROUND(A2/10,3))*10 | 方法14: | 26 | =ROUNDDOWN(A2,2-COLUMN()) | 24 | =LEFT(B2,LEN(B2)-1)&"0" | 方法15: | 27 | =FLOOR(A2,10^(COLUMN()-2)) | 24 | =TEXT(INT(A2/10),"0")&0 | 方法16: | 27 | =--LEFT(A2,FIND(".",A2)-1) | 26 | =INT(A2)-RIGHT(INT(A2),1) | 方法17: | 27 | =LEFT(A2,FIND(".",A2)-1)*1 | 26 | =ROUNDDOWN(A2,2-COLUMN()) | 方法18: | 27 | =ROUNDDOWN($A2,2-COLUMN())
| 27 | =CEILING(ROUND(A2-10,),10) | 方法19: | 29 | =LEFT(A2,FIND(".",A2,1)-1)*1 | 27 | =FLOOR(A2,10^(COLUMN()-2)) | 方法20: | 37 | =--LEFT(A2,FIND(".",A2+0.0000001)-1) | 29 | =LEFT(A2,FIND(".",A2)-2)&"0" | 方法21: | 51 | =TEXT(ROUNDDOWN(A2,COLUMN($B$2)-COLUMN(B2)),"000") | 31 | =(LEFT(A2,FIND(".",A2)-2)&0)*1 | 方法22: | 空 | 空 | 33 | =TEXT(ROUNDDOWN(A2,-1),"G/通用格式") | 方法23: | 空 | 空 | 35 | =LEFT(A2*10%,FIND(".",A2*10%)-1)&0 | 方法24: | 空 | 空 | 46 | =ROUNDDOWN(--LEFT(A2,FIND(".",A2)-1)/10,0)*10 | 方法25: | 空 | 空 | 51 | =TEXT(ROUNDDOWN(A2,COLUMN($B$2)-COLUMN(C2)),"000") |
【函数初级201203班】练习3-1228.rar
(8.44 KB, 下载次数: 55)
|