ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ìF©óIF¦h±ø¥ó¥Îªk¤½¦¡

[µo°Ý] ìF©óIF¦h±ø¥ó¥Îªk¤½¦¡

I9~I100¬OÃþ§O
F9~F100¬Oª÷ÃB
¥Ø¼ÐÀx¦s®æ±q
G9~G100

·Q­nªº°µªk¬O¡K ¦pªGÃþ§O¬O °£¯²¸î¥~ªº
¤@«ß³£¬Oª÷ÃB*3%ªº­È
©Ò¥H§Ú¼g¤F¥H¤U³o²Õ¤½¦¡
¦ý¬OÅã¥Ü¿ù»~  =IF(I9,"<>¯²¸î*",F9*3%)
«á¨Ó§ï¦¨  =IF(I9:I100,"<>¯²¸î*",F9:F100*3%)
©ÎªÌ
=IF(I9,"·~ÁZ",F9*3%) ¤]¬O¤£¦æ

Ãþ§O¶µ¥Ø¤À¬°5¤j¶µ
·~°È¡Bªù¥«¡B¥N²z¡B¯²¸î¡B¨ä¥¦
»Ý­n*3%¥u¦³·~°È¡Bªù¥«¡B¥N²z


¥H¤W§Ú¼gªº¤½¦¡
EXCEL§PÂ_¿ù»~
½Ð°Ý«ç»ò­×§ï¤~¹ï©O?

ÁÂÁÂ

=IF(OR(I9={"·~°È","ªù¥«","¥N²z"}),F9*3%,"")

TOP

¦^´_ 1# hairyhead

µo²{¼Ó¥D¹ïIFªº¥Îªk¦³ÂI¤p»~¸Ñ

IF(§PÂ_¦¡,°Ê§@A,°Ê§@B)

²³æ¨Ó»¡¥i¥H§âIF´N¬O ¡A«e­±§PÂ_±ø¥ó¹ïªº¸Ü¡A´N¦^¶ÇA¡A§_«h¦^¶ÇB

©Ò¥H¦pªG»Ý­n*3%¥u¦³·~°È¡Bªù¥«¡B¥N²z

==> IF(AND(I9<>"¯²¸î",I9<>"¨ä¥L"),F9*0.03,F9)

´NÅܦ¨  ¦pªGI9 ¤£¬O¯²¸î¤]¤£¬O¨ä¥L¶µ¥Øªº¸Ü¡A´N¦^¶ÇF9*0.03¡A§_«hª½±µ¦^¶ÇF9

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-1-24 06:51 ½s¿è

¦^´_ 1# hairyhead


¤]¥i¥H¨Ï¥Î¬d¸ß¨ç¼ÆVLOOKUP¡A·í§PÂ_¦h®É¤ñ¸û¦³¼u©Ê¡C
¯²¸î¡B¨ä¥¦ ¥¼©w¸q¡A¥ý°²³]¬°0¡C

=F9*VLOOKUP(I9,{"·~°È",0.03;"ªù¥«",0.03;"¥N²z",0.03;"¯²¸î",0;"¨ä¥¦",0},2,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ML089 ª©¥D¤£¦n·N«ä,§Ú¦³¤@­ÓºÃ°Ý, ¦bµ{¦¡ùØ¥Î{·~°È",0.03;"ªù¥«",0.03;"¥N²z",0.03;"¯²¸î",0;"¨ä¥¦",0 } "{}" ©O­Ó²Å¸¹¬O¦³¤°»ò¯S§O¥Î³~©O??
½Ð½ç±Ð
ÁÂÁÂ

TOP

·PÁ¸ѵª~
¤§«eÁ`ı±o­þ¸Ì©Ç©Ç
¸g»¡©úÁ`ÁA¸Ñ²M·¡¤F

TOP

«á¨Ó¸Õ¤F¤@¤U¦¹¤½¦¡
=IF(AND(I9<>"¯²¸î",I9<>"¨ä¥L"),F9*0.03,F9)
µo²{·í¤£¬O¯²¸î©Î¨ä¥¦Ãþ§O®É
F9¥¦¦^¶Çªº­ÈÁÙ¬O¤£·|ÅÜ©O?
¨Ò¦p¡K F9¬°100
·íI9Ãþ§O¬°·~°È³¡¡AF9«h¬°3
­YI9Ãþ§O§ï¬°¯²¸î¡AF9ÁÙ¬Oµ¥©ó3¤£ÅÜ

¥t¤@­Ó¤½¦¡
=IF(OR(I9={"·~°È","ªù¥«","¥N²z"}),F9*3%,"")
¥N¤J¤§«áF9³£¬OªÅ¥Õªº

³Ì«á¤@­Ó¤½¦¡
=F9*VLOOKUP(I9,{"·~°È",0.03;"ªù¥«",0.03;"¥N²z",0.03;"¯²¸î",0;"¨ä¥¦",0},2,)
¥X²{#N/A

¤£ª¾¹D§Ú­þ­Ó°Ê§@¿ù¤F©O?
¦pªGI9~I100§Ú¬O°µ¦¨¤U©Ô¦¡ªº²M³æ
³oÀ³¸Ó¤£·|¦³¤°»ò¼vÅT§a
¸ê®ÆÅçÃÒ=>³]©w=>²M³æ
="Á`ªí"! $B$4 : $G$4
³o¬O¥h±aÃþ§O¸Ìªº¶µ¥Ø

TOP

¦^´_ 7# hairyhead

¬Ý°_¨ÓÀ³¸Ó¬O¦Û°Ê­pºâªº¿ï¶µ¨S¦³¤Ä¿ï¨ì

¦pªG¬O07ª©¥»ªº¸Ü   ¦b¥ª¤W¤èoffice=>Excel¿ï¶µ=>¤½¦¡=>­pºâ¿ï¶µ¸Ì  §â¦Û°Ê­pºâ°é¿ï°_¨Ó

¦pªG»¡¬O¤½¦¡§PÂ_§¹¤£¬O¯²¸î¤]¤£¬O¨ä¥LÃþ§O¡A¼Ó¥D·Q­n°µ¨ä¥L°Ê§@ªº¸Ü  «Øij¥i¥H§ó§ï  IF(A,B,C)¡ACªº¦ì¸m

==>¹³³o­Ó IF(OR(I9={"·~°È","ªù¥«","¥N²z"}),F9*3%,"") ¥N¤J¤§«áF9³£¬OªÅ¥Õªº¡A¦]¬°¤½¦¡¦b³]¸mªº®É­Ô´N¬O ¦pªGI9¬O·~°È©Îªù¥«©Î¥N²z³o¤TÃþ¨ä¤¤¤§¤@¡AF9*3%¡B§_«h³£¦^¶ÇªÅ¥Õ­È

==>IF(AND(I9<>"¯²¸î",I9<>"¨ä¥L"),F9*3%,F9)  ³oÃä´N¬O»¡¦pªGI9¤£¬O¯²¸î¤]¤£¬O¨ä¥LÃþ§O¡A´NF9*3%¡A§_«h¦^¶ÇF9


¥H¤W  ¬Ý¯à¤£¯àÀ°¨ì§A~

TOP

¦^´_ 7# hairyhead

=F9*VLOOKUP(I9,{"·~°È",0.03;"ªù¥«",0.03;"¥N²z",0.03;"¯²¸î",0;"¨ä¥¦",0},2,)
¥X²{#N/A

½Ð¬Ý I9 ¬O¬Æ»ò­È¡AÀ³¸Ó¤£ {"·~°È";"ªù¥«";"¥N²z";"¯²¸î";"¨ä¥¦"} ³o5­Ó­È

{...} ¬Oªí¹F {}¤ºªº¸ê®Æ¬°°}¦C¸ê®Æ

; ³o²Å¸¹¬O¸ê®Æ¬°««ª½°}¦C  {"·~°È";"ªù¥«";"¥N²z";"¯²¸î";"¨ä¥¦"}
, ³o²Å¸¹¬O¸ê®Æ¬°¤ô¥­°}¦C  {"·~°È","ªù¥«","¥N²z","¯²¸î","¨ä¥¦"}
2ºû°}¦C  {"·~°È";"ªù¥«";"¥N²z";"¯²¸î";"¨ä¥¦"}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁª©¥D»¡©ú,·Q¤£¨ìIFÁÙ¦³³o¼Ëªº¨Ï¥Î¤è¦¡

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD