wps鎬庝箞鍥涜垗浜斿叆鍙栨暣
扬州沐宇科技
2023-10-18 14:01:56
wps
鍦╓PS涓紝鍙互浣跨敤ROUND鍑芥暟杩涜鍥涜垗浜斿叆鍙栨暣鎿嶄綔銆?/p>
ROUND鍑芥暟鐨勫熀鏈娉曚负锛?/p>
ROUND(number, num_digits)
鍏朵腑锛宯umber琛ㄧず瑕佽繘琛屽洓鑸嶄簲鍏ユ搷浣滅殑鏁板€硷紝num_digits琛ㄧず瑕佷繚鐣欑殑灏忔暟浣嶆暟銆?/p>
渚嬪锛岃灏?.14159淇濈暀涓や綅灏忔暟杩涜鍥涜垗浜斿叆鍙栨暣锛屽彲浠ヤ娇鐢ㄤ互涓嬪叕寮忥細
ROUND(3.14159, 2)
杩欏皢杩斿洖3.14銆?/p>
濡傛灉瑕佽繘琛屾暣鏁扮殑鍥涜垗浜斿叆鍙栨暣锛屽彲浠ュ皢num_digits鍙傛暟璁剧疆涓?銆備緥濡傦紝瑕佸皢3.6杩涜鍥涜垗浜斿叆鍙栨暣锛屽彲浠ヤ娇鐢ㄤ互涓嬪叕寮忥細
ROUND(3.6, 0)
杩欏皢杩斿洖4銆?/p>
娉ㄦ剰锛歊OUND鍑芥暟浼氭牴鎹畁umber鍙傛暟鐨勫皬鏁伴儴鍒嗗喅瀹氬彇鏁存柟鍚戯紝濡傛灉灏忔暟閮ㄥ垎澶т簬绛変簬0.5锛屽皢杩涜鍥涜垗浜斿叆锛涘鏋滃皬鏁伴儴鍒嗗皬浜?.5锛屽皢杩涜鍥涜垗浜斿叆銆?/p>
