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

¥i¥H¦A²¤Æ»yªk¶Ü

¥i¥H¦A²¤Æ»yªk¶Ü

¦U¦ì¥ý¶i¤U¦C»yªk¬O§_¥i¥H²¤Æ

»¡©ú:
°²¦p"D5>E5©ÎE5=0"ªº¸Ü¡A´N°µ"¶i¦ì¨ì³Ì±µªñ¤§­¿¼Æ"¡A¤£µM´N°²¦p"D5<=E5 ®É´NªÅ¥Õ",¤£µM´N°µ"¶i¦ì¨ì³Ì±µªñ¤§­¿¼Æ"

=IF((D5>E5)*(E5=0),(F5*CEILING(H5/F5,1)),(IF(D5<=E5,"",(F5*CEILING(H5/F5,1)))))


¬O§_¥i¥H²¤Æ?
Just do it.

¦U¦ì¥ý¶i¤U¦C»yªk¬O§_¥i¥H²¤Æ

»¡©ú:
°²¦p"D5>E5©ÎE5=0"ªº¸Ü¡A´N°µ"¶i¦ì¨ì³Ì±µªñ¤§­¿¼Æ"¡A¤£µM´N°²¦p"D ...
jsc0518 µoªí©ó 2017-5-30 13:28



    §A³Ì¦n¥ý©ú½T¤Æ¦Û¤v­nªºÅÞ¿è¡A§O¤H¤~¯àÀ°¦£
    ¥t¥~¡A
    °²¦p"D5>E5©ÎE5=0"ªº¸Ü¡A¡u©Î¡v¡A¤½¦¡¸Ìªºªº ¬P¸¹ ­n§ï¦¨ ¥[ ¸¹
    =IF((D5>E5)+(E5=0),..................

TOP

¦^´_ 2# KCC
ÁÂÁ±zªº¦^ÂÐ! ^_^
§Ú»¡©ú²M·¡¤@ÂI
§Ú¦³»Ý¨D¶q¡B®w¦s¶q¡B½ÐÁÊ°ò¼Æ¡B¸É®w¶q¡BÀ³±ÄÁʼƶq
ÅÞ¿è¬O-->À³±ÄÁʶq=»Ý¨D¶q-®w¦s¶q/½ÐÁÊ°ò¼Æ
¦p
D9»Ý¨D¶q=3000
E9®w¦s¶q=425
F9½ÐÁÊ°ò¼Æ=1000
H9¸É®w¶q=(3000-425)=2575
I9À³±ÄÁÊ¥ó¼Æ=3000(¦]¸É®w¶q¬°2575¡A¨C¦¸½ÐÁÊ»Ý1000°_¸õ¡A¬G¤£¨¬3000¡A¥H3000½ÐÁÊ)
Just do it.

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2017-6-1 22:40 ½s¿è

¦^´_ 3# jsc0518

D5=IF(A5>B5,A5-B5,"")
E5=IF(D5="","",CEILING(A5-B5,C5))

A:E¬°  »Ý¨D ®w¦s °ò¼Æ À³¸É À³ÁÊ

TOP

¦^´_  KCC
ÁÂÁ±zªº¦^ÂÐ! ^_^
§Ú»¡©ú²M·¡¤@ÂI
§Ú¦³»Ý¨D¶q¡B®w¦s¶q¡B½ÐÁÊ°ò¼Æ¡B¸É®w¶q¡BÀ³±ÄÁʼƶq
ÅÞ¿è ...
jsc0518 µoªí©ó 2017-6-1 18:27


i5==ROUNDUP((IF(D5<E5,E5,D5)-E5)/F5),0)*F5
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

TOP

¦^´_ 5# eigen


ÁÂÁ±zªº¦^ÂСA§Ú¸Õ¸Õ¼Ú!
Just do it.

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD