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

¨Ì¼Æ¦r¥h´M§ä¹ï·Óªí,±a¥X¯Å¶Z¸ê®Æ

¨Ì¼Æ¦r¥h´M§ä¹ï·Óªí,±a¥X¯Å¶Z¸ê®Æ

BÄ椽¦¡³]©w¡G
¨ÌAÄæ¼Æ¦r¥h¹ï·ÓDÄæ¡A±NDÄ檺¸ê®Æ±a¤JBÄæ

¬¡­¶Ã¯10.zip (6.62 KB)

joyce

=LOOKUP(A2,{0,101,201,301,401,501},D$2:D$7)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# hcm19522


    ÁÂÁ¸ѵª
joyce

TOP

101~199 ¨º200Âk­þ¸Ì
201~299 ¨º300Âk­þ¸Ì
301~399 ¨º400Âk­þ¸Ì
401~499
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089


    §ó¥¿¯Å¶Zªí¡G
¯Å¶Zªí
99¥H¤U
100~199
200~299
300~399
400~499
500¥H¤W

ÁÂÁ´£¿ô
joyce

TOP

¦^´_ 6# leiru


    =LOOKUP(A2,{0;1;2;3;4;5}*100,D$2:D$7)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


    ÁÂÁÂ
joyce

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD