wps表格怎么利用函数把如果单元格中含有某些字符则,在另一个单元格中返回数值? wps表格怎么利用函数把如果单元格中含有某些字符则,在另一个...
wps \u5982\u4f55\u5224\u65ad\u4e00\u4e2a\u5355\u5143\u683c\u6ee1\u8db3\u4e00\u4e2a\u5426\u53e6\u4e00\u4e2a\u6761\u4ef6\uff0c\u5219\u8fd4\u56de\u53e6\u4e00\u4e2a\u5355\u5143\u7684\u6570\u503c\uff0c\u5426\u5219\u663e\u793a\u7a7a\u767d\u8f93\u5165\u6761\u4ef6\u6c42\u548c\u516c\u5f0f\uff0c\u4e0d\u7528\u533a\u5206\u5927\u5c0f\u5199\u5b57\u6bcd\uff1a
=SUMIF(AN:AN,"*"&"0.6kg"&"*",R:R)
\u5982\u679c\u662f\u4efb\u4e00\u4e2a\u7b26\u5408\u5373\u53c2\u4e0e\u6c42\u548c\uff0c\u662f\u6216\u6761\u4ef6\uff0c\u76f4\u63a5\u4e24\u8005\u76f8\u52a0\u5373\u53ef\uff1a
=SUMIF(AN:AN,"*"&"0.6kg"&"*",R:R)+SUMIF(AN:AN,"*"&"0.5kg"&"*",R:R)
\u5728C1\u4e2d\u8f93\u5165\u6216\u590d\u5236\u7c98\u8d34\u4e0b\u5217\u516c\u5f0f
=IF(ISNUMBER(FIND("\u6709\u6548",A1)),B1,"")
A1\u5355\u5143\u683c\u5982\u679c\u542b\u6709\u201c\u6709\u6548\u201d\u8fd9\u4e24\u4e2a\u5b57\u7b26\uff0c\u5219\u663e\u793aB1\u7684\u503c\uff1b\u5426\u5219\uff0c\u663e\u793a\u7a7a\u503c\u3002
C2输入
=IF(ISNUMBER(FIND("定胚",A2)),1.5,"")
公式下拉
用find函数
绛旓細=IF(ISNUMBER(FIND("鏈夋晥",A1)),B1,"")A1鍗曞厓鏍濡傛灉鍚湁鈥滄湁鏁堚濊繖涓や釜瀛楃锛屽垯鏄剧ずB1鐨勫硷紱鍚﹀垯锛屾樉绀虹┖鍊笺
绛旓細C2杈撳叆 =IF(ISNUMBER(FIND("瀹氳儦",A2)),1.5,"")鍏紡涓嬫媺
绛旓細姝ラ1锛氬湪鍙充晶鐨勫皬琛ㄦ牸涓緭鍏ュ搴斿乏渚уぇ琛ㄦ牸鐨勭鍚嶄汉鐨勫悕瀛椼傛楠2锛氬湪鍙充晶灏忚〃鏍间腑杈撳叆鍏紡锛岄夋嫨瀵瑰簲鐨勫垪鍜岃銆備緥濡傦紝濡傛灉浣犺缁熻鐨勬槸绗1鍒楀拰绗1琛岀殑鏁板硷紝閭d箞浣犲彲浠ュ湪鍙充晶灏忚〃鏍肩殑绗簩琛岃緭鍏ヤ互涓嬪叕寮忥細=SUMIF(A1:A100,"鎸囧畾鐨勪汉鍚",B1:B100)姝ラ3锛氬皢鍏紡涓殑"鎸囧畾鐨勪汉鍚"鏇挎崲鎴愪綘鎯宠缁熻...
绛旓細棣栧厛鍦ㄧ數鑴戜笂鎵撳紑骞舵柊寤轰竴涓┖鐧WPS琛ㄦ牸绌虹櫧鏂囨。锛屽涓嬪浘鎵绀恒 鐐瑰嚮涓婃柟鑿滃崟鏍忛噷鐨勩愬叕寮忋戣彍鍗曪紝鍦ㄨ鑿滃崟涓嬪彲浠ョ湅鍒般愭彃鍏鍑芥暟銆戝姛鑳介夐」锛屽涓嬪浘鎵绀恒 鐐瑰嚮銆愭彃鍏ュ嚱鏁般戝姛鑳介夐」锛屽脊鍑烘彃鍏ュ嚱鏁扮獥鍙o紝閫氳繃璇ョ獥鍙e彲浠ラ夋嫨鍑芥暟绫诲埆锛岀敱浜庡嚱鏁伴兘鏄噰鐢ㄧ殑瀛楁瘝缂╁啓...
绛旓細棣栧厛锛岀敤鎴烽渶瑕佹墦寮WPS琛ㄦ牸锛屽苟瀹氫綅鍒版兂瑕佹彃鍏ュ嚱鏁扮殑鍗曞厓鏍笺鍦╓PS琛ㄦ牸涓紝鍑芥暟鏄鍏堝畾涔夊ソ鐨勭壒娈婂叕寮忥紝鍙互鐢ㄦ潵鎵ц澶嶆潅鐨勮绠楀拰鏁版嵁澶勭悊浠诲姟銆備緥濡傦紝SUM鍑芥暟鍙互鐢ㄦ潵姹傚拰锛孉VERAGE鍑芥暟鍙互璁$畻骞冲潎鍊硷紝鑰孖F鍑芥暟鍒欏彲浠ユ牴鎹潯浠惰繑鍥炰笉鍚岀殑缁撴灉銆傛帴涓嬫潵锛岀敤鎴烽渶瑕佸湪鍏紡鏍忎腑杈撳叆鎵閫夌殑鍑芥暟銆傝繖閫氬父鏄氳繃鐐瑰嚮...
绛旓細1. 鎵撳紑鍖呭惈鏁版嵁鐨勪袱涓琛ㄦ牸锛氱涓涓〃鏍硷紙涓昏〃鏍硷級鐢ㄤ簬杩涜缁熻璁$畻锛岀浜屼釜琛ㄦ牸锛堝弬鑰冭〃鏍硷級鍖呭惈浣犻渶瑕佸紩鐢ㄧ殑涓嶅悓鏃堕棿鐨勬暟鎹2. 鍦ㄤ富琛ㄦ牸涓紝鎵惧埌浣犺缁熻鐨勫崟鍏冩牸锛屽苟纭繚浣犵煡閬撻渶瑕佺粺璁$殑鏁版嵁鍒楀拰鏃堕棿鍒椼3. 鍦ㄤ富琛ㄦ牸涓紝浣跨敤鍏紡鎴鍑芥暟鏉ュ紩鐢ㄥ弬鑰冭〃鏍间腑鐨勬暟鎹傚叿浣撴柟娉曞彇鍐充簬浣犱娇鐢ㄧ殑WPS鐗堟湰鍜...
绛旓細鐞嗚В姝ゅ姛鑳藉悗锛屽崟鍑诲彇娑堝叧闂獥鍙c(濡傛灉鎮ㄥ崟鍑烩滅‘瀹氣濓紝鐒跺悗鎻掑叆鍑芥暟锛岀劧鍚庢墦寮涓涓悜瀵兼潵鎻掑叆鍑芥暟锛屽悜瀵间細寮曞鎴戜滑鎻掑叆鍑芥暟锛屼絾鏄幇鍦ㄦ垜浠笉瀹规槗鐞嗚В锛屾墍浠ュ厛鍗曞嚮鈥滃彇娑堚濓紝绋嶅悗鍐嶄粙缁嶅叾浠栦汉銆(涓鏃︽垜浠煡閬濡備綍浣跨敤杩欎釜鍑芥暟锛屾垜浠氨鍙互浣跨敤瀹冦傝涓嬪浘5-3-1銆531 娉細=骞冲潎鍊(c4:c6)绛変簬=骞冲潎鍊(c4锛...
绛旓細鍏蜂綋鎿嶄綔姝ラ濡備笅锛氶鍏堬紝鍦ㄩ渶瑕佽繘琛屾眰鍜岀殑鍗曞厓鏍间腑鐐瑰嚮榧犳爣宸﹂敭锛岃緭鍏モ=SUM(鈥濄傜劧鍚庯紝閫夋嫨闇瑕佹眰鍜岀殑鏁版嵁鎵鍦ㄧ殑鍗曞厓鏍艰寖鍥达紝鍙互閫氳繃鎷栧姩榧犳爣鎴栨墜鍔ㄨ緭鍏ュ崟鍏冩牸鑼冨洿鏉ラ夋嫨銆傛渶鍚庯紝鍦ㄨ緭鍏ユ涓緭鍏モ)鈥濆苟鎸変笅鍥炶溅閿紝鍗冲彲瀹屾垚姹傚拰鎿嶄綔銆浣跨敤蹇嵎閿繘琛屾眰鍜 闄や簡浣跨敤SUM鍑芥暟涔嬪锛WPS琛ㄦ牸杩樻彁渚涗簡蹇嵎閿潵...
绛旓細鍦ㄨ繖涓猈PS琛ㄦ牸鐨勬埅鍥句腑锛屾垜浠彲浠ョ湅鍒伴渶瑕佷粠涓鍒椾腑鏍规嵁鏉′欢閫夋嫨骞跺尮閰嶅彟涓鍒椾腑鐨勬暟鎹備负浜嗚В鍐宠繖涓棶棰橈紝鍙互浣跨敤WPS琛ㄦ牸涓殑`VLOOKUP`锛堟煡鎵撅級鍑芥暟鎴栬卄INDEX`鍜宍MATCH`缁勫悎鍑芥暟銆備娇鐢╒LOOKUP鍑芥暟 濡傛灉浣犻渶瑕佹牴鎹壒瀹氱殑鏉′欢锛堜緥濡傜紪鍙凤級浠庝竴鍒椾腑鏌ユ壘骞惰繑鍥炵浉搴旂殑鏁版嵁锛屼綘鍙互浣跨敤`VLOOKUP`鍑芥暟銆傚亣璁句綘闇瑕...
绛旓細鍦↖2涓緭鍏ユ垨澶嶅埗绮樿创涓嬪垪鍏紡 =IF(ISNUMBER(FIND("椹",H2)),H2,"")涓嬫媺濉厖