⑴ 鐢靛瓙琛ㄦ牸鎬庝箞濉鍏呯櫨浣嶅簭鍒楁暟瀛楋紵
涓句釜渚嬪瓙:
⑵ EXCEL鏁版嵁鎬庢牱鍘諱綅綺劇『鍒扮櫨浣
鍋囪炬暟鎹鍐欏湪A1鍗曞厓鏍礆紝瑕佸緱鍑篈1鍗曞厓鏍煎悜涓嬭垗鍘誨埌鐧句綅鐨勬暟鎹錛屽垯鍙浠ュ湪A1浠ュ栫殑浠諱竴鍗曞厓鏍煎啓鍏ュ叕寮忥細
鍏寮忎竴
=INT(A1/100)*100
INT鍑芥暟瀹氫箟
灝嗘暟瀛楀悜涓嬭垗鍏ュ埌鏈鎺ヨ繎鐨勬暣鏁般
璇娉
INT(number)
Number 闇瑕佽繘琛屽悜涓嬭垗鍏ュ彇鏁寸殑瀹炴暟銆
鍏寮忎簩
=TRUNC(A1/100)*100
TRUNC鍑芥暟瀹氫箟
灝嗘暟瀛楃殑灝忔暟閮ㄥ垎鎴鍘伙紝榪斿洖鏁存暟銆
璇娉
TRUNC(number,num_digits)
Number 闇瑕佹埅灝懼彇鏁寸殑鏁板瓧銆
Num_digits 鐢ㄤ簬鎸囧畾鍙栨暣綺懼害鐨勬暟瀛椼侼um_digits 鐨勯粯璁ゅ間負 0銆
璇存槑
鍑芥暟 TRUNC 鍜屽嚱鏁 INT 綾諱技錛岄兘榪斿洖鏁存暟銆傚嚱鏁 TRUNC 鐩存帴鍘婚櫎鏁板瓧鐨勫皬鏁伴儴鍒嗭紝鑰屽嚱鏁 INT
鍒欐槸渚濈収緇欏畾鏁扮殑灝忔暟閮ㄥ垎鐨勫礆紝灝嗗叾鍥涜垗浜斿叆鍒版渶鎺ヨ繎鐨勬暣鏁般傚嚱鏁 INT 鍜屽嚱鏁 TRUNC 鍦ㄥ勭悊璐熸暟鏃舵湁鎵涓嶅悓銆
鍏寮忎笁
=ROUNDDOWN(A1,-2)
ROUNDDOWN鍑芥暟瀹氫箟
闈犺繎闆跺礆紝鍚戜笅錛堢粷瀵瑰煎噺灝忕殑鏂瑰悜錛夎垗鍏ユ暟瀛椼
璇娉
ROUNDDOWN(number,num_digits)
Number 涓洪渶瑕佸悜涓嬭垗鍏ョ殑浠繪剰瀹炴暟銆
Num_digits 鍥涜垗浜斿叆鍚庣殑鏁板瓧鐨勪綅鏁般
璇存槑
- 鍑芥暟 ROUNDDOWN 鍜屽嚱鏁 ROUND 鍔熻兘鐩鎬技錛屼笉鍚屼箣澶勫湪浜庡嚱鏁癛OUNDDOWN 鎬繪槸鍚戜笅鑸嶅叆鏁板瓧銆
- 濡傛灉 num_digits 澶т簬 0錛屽垯鍚戜笅鑸嶅叆鍒版寚瀹氱殑灝忔暟浣嶃
- 濡傛灉 num_digits 絳変簬 0錛屽垯鍚戜笅鑸嶅叆鍒版渶鎺ヨ繎鐨勬暣鏁般
- 濡傛灉 num_digits 灝忎簬 0錛屽垯鍦ㄥ皬鏁扮偣宸︿晶鍚戜笅榪涜岃垗鍏ャ
鍏寮忓洓
=FLOOR(A1,100)
FLOOR鍑芥暟瀹氫箟
灝嗗弬鏁 Number 娌跨粷瀵瑰煎噺灝忕殑鏂瑰悜鍚戜笅鑸嶅叆錛屼嬌鍏剁瓑浜庢渶鎺ヨ繎鐨 significance 鐨勫嶆暟銆
璇娉
FLOOR(number,significance)
Number 鎵瑕佸洓鑸嶄簲鍏ョ殑鏁板箋
Significance 鍩烘暟銆
璇存槑
- 濡傛灉浠諱竴鍙傛暟涓洪潪鏁板煎弬鏁幫紝鍒 FLOOR 灝嗚繑鍥為敊璇鍊 #VALUE!銆
- 濡傛灉 number 鍜 significance 絎﹀彿鐩稿弽錛屽垯鍑芥暟 FLOOR 灝嗚繑鍥為敊璇鍊 #NUM!銆
- 涓嶈 number 鐨勬ｈ礋鍙峰備綍錛岃垗鍏ユ椂鍙傛暟鐨勭粷瀵瑰奸兘灝嗗噺灝忋傚傛灉 number 鎮板ソ鏄 significance 鐨勫嶆暟錛屽垯鏃犻渶榪涜屼換浣曡垗鍏ュ勭悊銆