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

²Ê²¤¦ô­p

²Ê²¤¦ô­p

²Ê²¤¦ô­p.zip (7.51 KB)

¦^´_ 1# Qin


    E4 =ROUND(SUM(INT(D4/MID(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B4,I:K,3,),"g",),"-",REPT(" ",9)),{0,1}*9+1,9)))/2,0)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD