⑴ 鐢靛瓙琛ㄦ牸镐庝箞濉鍏呯栌浣嶅簭鍒楁暟瀛楋纻
涓句釜渚嫔瓙:
⑵ 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 镄勫嶆暟锛屽垯镞犻渶杩涜屼换浣曡垗鍏ュ勭悊銆