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

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

¦^´_ 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

¦^´_ 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

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD