- ©«¤l
- 12
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-12-4
- ³Ì«áµn¿ý
- 2016-10-8
|
«á¨Ó¸Õ¤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¸Ìªº¶µ¥Ø |
|