excel涓璱f鍑芥暟濡備綍浣跨敤
扬州沐宇科技
2023-09-29 07:22:23
excel
IF鍑芥暟鍦‥xcel涓敤浜庡湪婊¤冻鐗瑰畾鏉′欢鏃惰繑鍥炰笉鍚岀殑鍊笺€傚叾璇硶濡備笅锛?/p>
=IF(鏉′欢, 鍊?, 鍊?)
鍏朵腑锛屾潯浠舵槸涓€涓€昏緫琛ㄨ揪寮忥紝濡傛灉涓虹湡锛屽垯杩斿洖鍊?锛屽惁鍒欒繑鍥炲€?銆備笅闈㈡槸涓€浜汭F鍑芥暟鐨勭ず渚嬶細
- 濡傛灉A1鍗曞厓鏍肩殑鍊煎ぇ浜?0锛屽垯杩斿洖"澶т簬10"锛屽惁鍒欒繑鍥?quot;灏忎簬绛変簬10"锛?/li>
=IF(A1>10, 鈥滃ぇ浜?0鈥? 鈥滃皬浜庣瓑浜?0鈥?
- 濡傛灉B1鍗曞厓鏍肩殑鍊间负"鐢?quot;锛屽垯杩斿洖"鍏堢敓"锛屽惁鍒欒繑鍥?quot;濂冲＋"锛?/li>
=IF(B1=鈥滅敺鈥? 鈥滃厛鐢熲€? 鈥滃コ澹€?
- 濡傛灉C1鍗曞厓鏍肩殑鍊间负绌猴紝鍒欒繑鍥?quot;绌哄€?quot;锛屽惁鍒欒繑鍥濩1鐨勫€硷細
=IF(C1=鈥溾€? 鈥滅┖鍊尖€? C1)
鍊?鍜屽€?鍙互鏄枃鏈€佹暟瀛椼€佸叕寮忔垨鍏朵粬鍗曞厓鏍肩殑寮曠敤銆侷F鍑芥暟鍙互宓屽浣跨敤锛岀敤浜庡鐞嗘洿澶嶆潅鐨勬潯浠跺垽鏂€?/p>
