- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-6-5 15:06 ½s¿è
¦^´_ 3# home1913
1¡B½Ð©óD2Àx¦s®æ¿é¤J
=IF((C2/VLOOKUP(A2,$F$2:$G$8,2,0))<1,C2*2,(C2/VLOOKUP(A2,$F$2:$G$8,2,0))*10)
Äò©¹¤U½Æ»s¤½¦¡¡C
2¡B©ó±z©Òn§e²{µ²ªGªºÀx¦s®æ¿é¤J
=SUMIF(B2:D7,"Á`¤½¥q",D2:D7)
½Ð°Ñ¦Ò¡I |
|