excel
鏁板�煎彇鏁村強杩涗綅
鍙栨暣鏁板嚱鏁?/p>
907.5
锛?/p>
1034.2
锛?/p>
1500
瑕佹敼鍙樹负
908
锛?/p>
1035
锛?/p>
1500
鍏紡涓猴細
=CEILING(A1,1)
907
锛?/p>
1034
锛?/p>
1500
瑕佹敼鍙樹负
910
锛?/p>
1040
锛?/p>
1500
鍏紡涓猴細
=CEILING(A1,10)
濡傛灉瑕佷繚鐣欏埌鐧句綅鏁帮紝鍗虫敼鍙樹负
1000
锛?/p>
1100
锛?/p>
1500
鍏紡涓猴細
=CEILING(A1,100)
鏁板�煎彇鏁?/p>
鍦ㄥ崟鍏冩牸涓鍙栨暣鏁?/p>
锛堝彧鍙栨暣鏁颁笉鐢ㄨ�冭檻鍥涜垗浜斿叆锛?/p>
鐢ㄤ粈涔堝嚱鏁板憖锛熶緥濡傦細
10/4
鍙鏄剧ず
2
灏卞彲浠ヤ簡锛佽鑰冭檻璐熸暟鐨勫洜鏁板憿锛熶緥濡傦細
(-10/4)
瑕佹樉绀猴紞
2
鑰屼笉鏄紞
3
锛?/p>
鎬庝箞鍔烇紵
=TRUNC(A1,0)
=ROUNDDOWN(A1,0)
姹備綑鏁扮殑鍑芥暟
姣斿锛?/p>
A1=28
锛?/p>
A2=
锛?/p>
A1
梅
6
锛夌殑浣欐暟
=4
锛岃闂繖涓叕寮忔�庝箞鍐欙紵
瑙ｇ瓟锛?/p>
=MOD(28,6)
鍥涜垗浜斿叆鍏紡
=ROUND()
=ROUND($B$1*A1,2)
=ROUND(B1*A1,2)
=round(a1,0)
=round(a1,0)*0.95
瀵规暟瀛楄繘琛屽洓鑸嶄簲鍏?/p>
瀵逛簬鏁板瓧杩涜鍥涜垗浜斿叆
,
鍙互浣跨敤
INT
锛堝彇鏁村嚱鏁帮級锛屼絾鐢变簬杩欎釜鍑芥暟鐨勫畾涔夋槸
杩斿洖瀹炴暟鑸嶅叆鍚庣殑鏁存暟鍊笺�?/p>
鍥犳锛?/p>
鐢?/p>
INT
鍑芥暟杩涜鍥涜垗浜斿叆杩樻槸闇�瑕佷竴浜涙妧宸х殑锛?/p>
涔?/p>
灏辨槸瑕佸姞涓?/p>
0.5
锛屾墠鑳借揪鍒板彇鏁寸殑鐩殑銆傚叕寮忓簲鍐欐垚锛?/p>
=INT(B2*100+0.5)/100
濡備綍瀹炵幇鈥滆鍒嗚繘鍏冣�?/p>
鍦ㄦ垜浠殑宸ヨ祫涓紝
鏈変竴椤?/p>
鈥滃悎鍚岃ˉ璐粹�?/p>
锛?/p>
鍙璁＄畻缁撴灉鍑虹幇
鈥滃垎鈥?/p>
鍊煎氨鍦ㄦ暣鏁?/p>
鈥滃厓鈥?/p>
杩涗竴浣嶏紝涔熷氨鏄
3.01
鍏冭繘鍒?/p>
4.00
鍏冿紝
3.00
鍏冧笉鍙橈紝鏁存暟鈥滃厓鈥濅笉鍙樸�?/p>
=IF((A3-INT(A3))>=0.3,IF((A3-INT(A3))>=0.8,1,0.5),0)+INT(A3)
锛?/p>
IF(RIGHT(FIXED(A1,2),2)>B1,TRUNC(A2)+1,A2)
璇存槑涓�涓嬶細
A1
鍗虫槸瑕佽浆鎹㈢殑鐩爣锛?/p>
B2
杈撳叆
00
锛堟枃鏈牸寮忥紝
蹇呴』鏄?/p>
00
杩欎袱涓暟锛?/p>
銆?/p>
锛?/p>
IF(INT(A1)<>A1,INT(A1)+1,A1)