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

[µo°Ý] E2¸Þ²§ªº¼Æ­È

[µo°Ý] E2¸Þ²§ªº¼Æ­È

E2ªº­È«Ü©_©Ç.rar (2.28 KB)

½ÐÀ°¦£¬Ý¤@¤UÀɮפºE2ªº­È¬°¤°»ò¤£¬O0
¦Ó¬O©Çªº­È©O

¶i¦Ó¾É­PFÄ檺§PÂ_¤]¦³°ÝÃD

¬O­þ­Ó¦a¤è¥X²{°ÝÃD©O¡H
¦³¤°»ò¤è¦¡¥i¥H¸Ñ¨Mªº¶Ü¡H

¦^´_ 1# rakefrank


¯«¯µªº1.86@@¡Akey¨ä¥L¼Æ­ÈÁÙ¤£·|³o¼Ë§o¡A
³o­Ó°ÝÃD¦ü¥G¬O­ÓÄa®×¤F¡C

TOP

¯BÂI¹BºâªºBUG,¥ÎROUND()¥h°£

TOP

¯BÂI¹BºâªºBUG,¥ÎROUND()¥h°£

TOP

¹ï§q
ÁÙ¦³ROUND³o­Ó¨ç¼Æ¥i¥H¥Î
·PÁ¤j¤jªº´£¿ô

TOP

¦^´_ 1# rakefrank
  1. =IF(OR(B2>0,C2>0,D2>0),D2-(B2+C2)," - ")
½Æ»s¥N½X
§ï¦¨
  1. =ROUNDUP(IF(OR(B2>0,C2>0,D2>0),D2-(B2+C2)," - "), 2)
½Æ»s¥N½X
«K¦æ¤F¡C  ©Ò¥H E2 = -0.01

TOP

¦^´_ 6# c_c_lai

ROUNDUP¬O­Ó«Ü¦³½ìªº¨ç¼Æ
¤§«e±q¨Ó¨S¥Îªº
¤£¹L¦n¹³¸ò§Ú·Q­nªºµ²ªG¤£¤Ó²Å¦X
§Ú­nªº¬OE2=D2-(B2+C2)=1.86-(1.86+0)=0
¨Ï¥ÎROUNDUP«áÅܦ¨-0.01¦ü¥G¤£¬O§Ú·Q­nªºµ²ªG
§Ú¥Ø«e±NE2=IF(OR(B2>0,C2>0,D2>0),ROUND(D2-(B2+C2),2)," - ")
¤£¹L¾Ç¤F¤@­Ó·s¨ç¼Æ¤]¬O®¼¦n

TOP

¦^´_ 1# rakefrank

Åã¥Ü­È¬°·Ç
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh

ÁÙ¦³³oºØ¯S§Oªº¥Îªk
·PÁ´£¨Ñ
¤S¾Ç¨ì·sªF¦è

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD