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

[µo°Ý] EXCEL ¼úª÷­pºâ¤½¦¡

[µo°Ý] EXCEL ¼úª÷­pºâ¤½¦¡

½Ð±Ð¦U¦ì¤j¤j
¦]¤u§@»Ý­n­pºâ¦P¤¯ÁZ®Ä
¥H¨Ì¦U¯Å¶Z¼g¥X»â¼úª÷¤½¦¡
·~ÁZ             ¼úª÷
10¸U-11¸U   $1600
12¸U-20¸U   $2000
20¸U-30¸U   $2500
30¸U¥H¤W     $3000
=SUMPRODUCT(($F$28>={100000,120000,200000,300000})*{1,1,1,1},{1600,400,500,500})
¨ä¤¤$F$28¬O¦P¤¯·í¤ëªºÁZ®Ä¡C
²{¦bªº°ÝÃD¬O:
¦³¨Ì¾µ¥»{©w¸Õ¥Î´ÁÀ³°µÁZ®Ä¡A¦pªG7¾µ¥·í¤ë°µ¤£¨ì12¸U¡A¼úª÷´î¥b:¹ê»â$800
³o³¡¤ÀÀ³¸Ó«ç»ò¤U¤½¦¡©O?
¬O¤£¬OÀ³¸Ó­n¤À¦¨¨â­Ó¤½¦¡:¤@­Ó¬O¸Õ¥Î´Á¨Ï¥Î¡A¤@­Ó¤@¯ë¥¿¦¡¥ô¥Î¦P¤¯¨Ï¥Î
ÁÂÁ«ü¾É¤F~~

http://blog.xuite.net/hcm19522/twblog/355702858

TOP

¦^´_ 1# ¶Ì§¬

³o¤½¦¡
=SUMPRODUCT(($F$28>={100000,120000,200000,300000})*{1,1,1,1},{1600,400,500,500})
¥i¥H²¤Æ¦p¤U
=LOOKUP($F$28%%,{10,12,20,30},{16,20,25,30}*100)

¦³¨Ì¾µ¥»{©w¸Õ¥Î´ÁÀ³°µÁZ®Ä¡A¦pªG7¾µ¥·í¤ë°µ¤£¨ì12¸U¡A¼úª÷´î¥b:¹ê»â$800
=LOOKUP($F$28%%,{0,10,12,20,30},{8,16,20,25,30}*100)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ¨â¦ì«e½úªº«ü±Ð
¯uªº«Ü¨ü¥Îªü~~

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD