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

if ±ø¥ó

if ±ø¥ó

½Ð±Ð, ªþ¥ó¤¤¦³³\¦h±ø¥óªº§PÂ_, ¥Îif ¨ç¼Æ±o¨ìªºµ²ªG¤£¬O«Ü¥¿½T.
¬O§_¦³¤ñ¸û¾A¦Xªº¨ç¼Æ? ©Î¬O¥i¥H¥Î¤°»ò¤è¦¡¨Ó°µ§PÂ_?
·PÁÂ.

Supplier list.zip (11.9 KB)

fangac

dear sir
50%<=G5>0§ï¬°  0<=g5-0.5,g5-0>0   ¤§¤è¦¡¬Ý¬Ý
ù

TOP

Supplier list.rar (17.33 KB)

I5¤½¦¡¡Aªí®æ¦¡§PÂ_¡A¸ê®Æ¦ì¸mªº¦w±Æ·|¼vÅT¤½¦¡ªº¼gªk¡A´£¨Ñ°Ñ¦Ò
=INDEX(AA$5:AA$17,MATCH(,0/((T$5:T$17=E5)*(F5>=U$5:U$17)*(F5<=V$5:V$17)*(G5>=X$5:X$17)*(G5<=Y$5:Y$17)*ROW($5:$17)),))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD