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

[µo°Ý] Î`杂数Õu¥­§¡数§P断¨ú­È问题 ?

¦^´_ 2# niko88819


    D3 =LOOKUP(D2,B2:B6-(B2:B6-N(OFFSET(B1,ROW(1:5)-1,)))/2,A2:A6)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­×¥¿
{=LOOKUP(D2,B2:B6-IF(ROW(1:5)=1,B3-B2,B2:B6-B1:B5)/2,A2:A6)}

{...} »Ý¥Î CTRL+SHIFT+ENTER ¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD