IF(($B3+$D3+$E3)/(1-15%)/$R$2<6.2407,($B3+$D3+$E3+1*$R$2)/$R$2,($B3+$D3+$E3)
如果($B3+$D3+$E3)/(1-15%)/$R$2小于6.2407，则显示($B3+$D3+$E3+1*$R$2)/$R$2，否则显示($B3+$D3+$E3）if函数，三个参数，1.判断2.如果是的话显示什么3.如果不是的话显示什么。
这个是很浅的意思了。如果B3+D3+E3)/(1-15%)/R2<6.2407则显示
(B3+D3+E3+1*R2)/R2否则显示B3+D3+E3
绛旓細濡傛灉($B3+$D3+$E3)/(1-15%)/$R$2灏忎簬6.2407锛屽垯鏄剧ず($B3+$D3+$E3+1*$R$2)/$R$2锛屽惁鍒欐樉绀($B3+$D3+$E3锛
绛旓細=IF(LEN(CONCATENATE($A3,$B3,$C3,$D3,$E3,$F3,$G3,$H3,$I3,$J3,$K3,$L3,$M3)-CONCATENATE($N3,$O3,$P3,$Q3,$R3,$S3,$T3,$U3,$V3,$W3,$X3,$Y3,$Z3))>(COLUMN($M3)-COLUMN(A3)),TEXT(MID(TEXT(CONCATENATE($A3,$B3,$C3,$D3,$E3,$F3,$G3,$H3,$I3,$J3,$...
绛旓細VLOOKUP澶氭潯浠舵煡鎵 =VLOOKUP(C3&"|"&D3&"|"&E3,IF({1,0},Sheet2!$B$3:$B$220&"|"&Sheet2!$C$3:$C$220&"|"&$D$3:$D$220,Sheet2!$E$3:$E$220),2,0)鍚屾椂鎸塁TRL SHIFT 鍥炶溅閿墽琛 娉ㄦ剰瀹為檯鐨勮鍙 涓嶈鐨勮瘽锛屽彂琛 [email protected] ...
绛旓細鍋囪C3鏍煎～鍐欑殑鏄柦宸ヨ繘灏洪暱搴︼紝D3鏍奸渶瑕佹牴鎹瓹3鏍肩殑鏁板艰嚜鍔ㄨ绠楀嚭A绫诲瀷鐨勯暱搴︼紝E3鏍奸渶瑕佹牴鎹瓹3鏍肩殑鏁板艰嚜鍔ㄨ绠楀嚭B绫诲瀷鐨勯暱搴︺備互涓嬫槸鍙互鐢ㄧ殑IF鍏紡锛欴3鏍煎叕寮忥細=IF(C3<=300,C3,IF(C3<=800,300,(C3-800)/2+300))杩欎釜鍏紡鐨勬剰鎬濇槸锛氬鏋淐3鏍肩殑鍊煎皬浜庣瓑浜300锛岄偅涔圖3鏍煎氨绛変簬C3鏍肩殑鍊硷紙涔...
绛旓細ALT+F11鈥斺擣7鈥斺旂矘璐村涓嬩唬鐮侊紝骞惰皟鏁翠箣锛岋紙鎹㈣瑕佸拰鎴戠殑涓鑷达級鈥斺擣5杩愯 Private Sub Worksheet_Change(ByVal Target As Range)On Error Resume Next If Target.Column = 4 And Target.Value <> "" Then Target.Offset(, 1) = Target.Offset(, 1).Value - Target.Value Target.Clear End...
绛旓細D3=IF(ISERROR(INDEX($A$2:$A$9,MATCH(0,COUNTIF($D$2:D2,$A$2:$A$9)+IF(COUNTIF($A$2:$A$9,$A$2:$A$9)>1,0,1),0))),"",INDEX($A$2:$A$9,MATCH(0,COUNTIF($D$2:D2,$A$2:$A$9)+IF(COUNTIF($A$2:$A$9,$A$2:$A$9)>1,0,1),0)))E3=IF(...
绛旓細if鏉′欢涓綋涓涓煎湪涓涓尯闂村唴锛屽嵆澶т簬鏌愬硷紝涓斿皬浜庢煇鍊兼椂锛屾槸涓嶅彲浠ュ啓鍦ㄤ竴璧风殑锛岃屾槸瑕佸垎寮鍐欍傛墍浠ュ叕寮 =IF(AND(D3<=275,$E3<=2.5),0.2*D3,IF(AND(D3>275,E3<=9,E3>2.5),0.2*D3,IF(AND(D3>1500,$E3>9),0.2*D3)))鍏紡鍦―3涓嶦3鍚屾椂鏈夊肩殑鏉′欢涓嬫墽琛屻傝嫢涓や釜鍗曞厓...
绛旓細鍦E3銆丳3銆丄A3涓垎鍒緭鍏ユ垨澶嶅埗绮樿创涓嬪垪鍏紡 =IF($B3=E$2,E$2,"")=IF($C3=P$2,P$2,"")=IF($D3=AA$2,AA$2,"")鍒嗗埆鍙虫媺濉厖锛屼笅鎷夊～鍏 鎴 娓呴櫎BCD杈呭姪鍒楃殑鏁版嵁 鍦‥3銆丳3銆丄A3涓垎鍒緭鍏ユ垨澶嶅埗绮樿创涓嬪垪鍏紡 =IF(LEFT($A3)-E$2=0,E$2,"")=IF(MID($A3,2,1)-P$2=...
绛旓細鍙敤IF涔熸湁寰堝鎬绘柟娉曪紝涓嬮潰涓哄叾涓竴绉嶃E3 =IF(C3="鐢","鐖",IF(C3="濂","姣","鏈煡"))&IF(C3="鏈煡","",IF(D3="鐢","瀛",IF(D3="濂","濂","鏈煡")))涓嬫媺澶嶅埗銆備篃鍙互閫氳繃鍒ゆ柇C3&D3=鈥滅敺鐢封濇垨鑰 鈥滅敺濂斥濊繖鏍疯繘琛屽垽鏂
绛旓細锛1锛夊湪鑱岀姸鎬佷笌浼戝亣鐘舵侊紝鍙互閫氳繃IF鍑芥暟鍒ゆ柇锛屽嵆IF(D3=鈥濆湪鑱屸,375,225)锛屽綋鐒朵篃鍙互鍐欐垚IF(D3=鈥濅紤鍋団,225,375)锛屽皢鍏朵綔涓篒F鍑芥暟鐨勭2涓弬鏁般傦紙2锛変笉婊¤冻棰嗗彇楂樻俯琛ュ姪鐨勬潯浠讹紝鍒欏彂0鍏冿紝灏嗗叾浣滀负绗3涓弬鏁般傚皢浠ヤ笂鍙傛暟缁勫悎鍒颁竴璧凤紝鍏紡濡備笅銆俆IPS锛欱1鍗曞厓鏍肩殑浣嶇疆鏄笉鑳藉彉鍖栫殑锛屾墍浠ュ簲灏...
