WORD
瀹岀編鏍煎紡
鎶�鏈祫鏂?/p>
涓撲笟鏁寸悊
宸ヤ綔涓渶甯哥敤鐨?/p>
excel
鍑芥暟鍏紡澶у叏锛屽府浣犳暣鐞嗛綈浜嗭紝鎷挎潵鍗崇敤
涓�銆佹暟瀛楀鐞?/p>
1
銆佸彇缁濆鍊?/p>
=ABS(
鏁板瓧
)
2
銆佸彇鏁?/p>
=INT(
鏁板瓧
)
3
銆佸洓鑸嶄簲鍏?/p>
=ROUND(
鏁板瓧
,
灏忔暟浣嶆暟
)
浜屻�佸垽鏂叕寮?/p>
1
銆佹妸鍏紡浜х敓鐨勯敊璇�兼樉绀轰负绌?/p>
鍏紡锛?/p>
C2
=IFERROR(A2/B2,"")
璇存槑锛氬鏋滄槸閿欒鍊煎垯鏄剧ず涓虹┖锛屽惁鍒欐甯告樉绀恒�?/p>
2
銆?/p>
IF
澶氭潯浠跺垽鏂繑鍥炲�?/p>
鍏紡锛?/p>
C2
=IF(AND(A2<500,B2="
鏈埌鏈?/p>
"),"
琛ユ
","")
璇存槑锛氫袱涓潯浠跺悓鏃舵垚绔嬬敤
AND,
浠讳竴涓垚绔嬬敤
OR
鍑芥暟銆?/p>