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

°ª¤â½Ð°ÝEXCEL¤¤ªºIF¥Îªk-¥æ¤e§PÂ_

°ª¤â½Ð°ÝEXCEL¤¤ªºIF¥Îªk-¥æ¤e§PÂ_

¤@¯ë¤é ¶g¤é¦Ü¶g¤­ $999
¶g¤» $1,599
¤C¤K¤ë ¶g¤é¦Ü¶g¤­ $1,299
¶g¤» $1,899

»yªk¤p§Ì¯uªº¼g¤£¥X¨Ó
¤p§Ì¥u©é±o¥X¨Ó¦p¤U
=IF((K12=7)*(K12=8)*(I14="¬P´Á¤»"),1599,IF((I14="¬P´Á¤»"),1599,999))
Àµ½Ð¤j­ô¤j©n­Ì¤F!
ÁÂÁ¦U¦ìªºÀ°¦£
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

½Ð¤W¶ÇÀÉ®×
§_«h¥Î²qªº¤£¨£±o¥¿½T
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¥D­n¬O²M¼ä¶O³Bªº¹Bºâ
ÁÂÁ¤j­ô

aaaaaaa.rar (8.02 KB)

²M¼ä¶O³B!

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¸Õ¸Õ¬Ý
=999+(I14="¬P´Á¤»")*600+((K12=7)+(K12=8))*300

TOP

D2=((MONTH($G$3)=7)+(MONTH($G$3)=8))*300+(WEEKDAY($G$3,2)=6)*600+999
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¬Ý¤£¨ì­ìÀÉ¡A­ÉHª©¥Dªº¤½¦¡¤@¥Î¡AÀ³¥ç¥i­×§ï¦p¤U¡A¥u¬O¤£ª¾¹Bºâ®Ä²v¦³¨S´£°ª¡H
D2=(((MONTH($G$3)=7)+(MONTH($G$3)=8))+(WEEKDAY($G$3,2)=6)*2)*300+999

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD