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

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

¦^´_ 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 : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD