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

·s¤â¨D§U VLOOKUP °ÝÃD «ô°U°ª¤â­ÌÀ°¦£¸Ñ´b

·s¤â¨D§U VLOOKUP °ÝÃD «ô°U°ª¤â­ÌÀ°¦£¸Ñ´b



¦p¹Ï ¨âªÌ¬Û´îµ²ªG¬O3.7  ¥i¬O¨ç¼Æ¶Ç¦^ªºµ²ªG¤£¬O10 ¤Ï¦Ó¬O25 (¦pªGrange_lookup§ï¦¨false «h·|¶Ç¦^#N/A)
©Ò¦³Àx¦s®æªº®æ¦¡³£¬O³q¥Î®æ¦¡
¦³¸Õ¹L§ó§ïA1¡BB1ªº¼Æ¦r¡AÅý¥L­Ì¬Û´îºû«ù3.7
¦ý©_©Çªº¬O ¦³®É­Ô¶Ç¦^10 ¦³®É­Ô¶Ç¦^25
¹³³o¼Ë


«ô°U¤j¤j­Ì §Ú­n«ç¼Ë­×§ï¤~¯àÅý¥L¶Ç¦^¥¿½Tªº­È

¦^´_ 1# wen821006

¥i¯à¬O¯BÂI¹Bºâªº»~®t­È©Ò³y¦¨
¨Ï¥ÎROUND()¨ç¼Æ¨ú¤p¼Æ1¦ì

=VLOOKUP(ROUND(A1-B1,1),A3:B7,2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD