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

¹F¦¨²vªº¤½¦¡

¹F¦¨²vªº¤½¦¡

½Ð°Ý­n­pºâ¹F¦¨²v(A/B=¹F¦¨²v),¦ý¬O°ò·Ç¦³­t¼Æ¤]¦³¥¿¼Æ,¤ñ¸ûÄæ¤]¦³¥¿¦³­t,¨º­n«ç»ò­pºâ¹F¦¨²v¤~¥¿½T ?
BOOK1.jpg
2012-3-13 15:19

¦^´_ 1# VANESSA

¬O§_¥¿­t¸¹ªº°ÝÃD?
C1=SIGN(B1-A1)*A1/B1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# VANESSA

¬Ý¬Ý¾A¤£¾A¥Î
C2=SIGN(A2-B2)*ABS((A2-B2)/B2)
1.jpg
2012-3-13 16:13

TOP

¹ï,µ²ªG´N¬O§Ú·Q­nªºµª®×,ÁÂÁÂ

TOP

²Ä¤@¦¸¬Ý¨ìSIGN«ü¥O,¯u¤£¿à!!
SIGN (Help»¡©ú)
¥þ³¡Åã¥Ü¥þ³¡ÁôÂèM©w¼Æ­Èªº¥¿­t¸¹¡C¦pªG¦¹¼Æ­È¬O¥¿¼Æ¡A·|¶Ç¦^ 1¡A¦pªG¬O 0 «h¶Ç¦^ 0¡A¦pªG¼Æ­È¬O­t¼Æ¡A«h¶Ç¦^ -1¡C

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD