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

¨Dµ´¹ï­È³Ì¤j¼Æ

¨Dµ´¹ï­È³Ì¤j¼Æ

¦U¦ì¤j¤j
¤p§Ìªº¤p¤p°ÝÃD
¨Dµ´¹ï­È³Ì¤j¼Æ¡A¥¿¸Ñ¬O-19¡A¦pªG¤£¥Îvb
À³¸Ó¦p¦ó¼g©O¡H
1
16
3
-19
-17
-11
18
12
-15
10
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

¦^´_ 13# GBKEE

ª©¥D

µª®×¬O#9¼Óªº¦^µªªü....
    ¦]¬°±zªº­ì¤å..
  ¨Dµ´¹ï­È³Ì¤j¼Æ¡A¥¿¸Ñ¬O-19¡A¦pªG¤£¥Îvb
  À³¸Ó¦p¦ó¼g©O¡H
©Ò¥H..
¬Ý¨Ó¬O§Ú»~¸Ñ¤F¡A¥H¬°¬O­n§ä¥X¥i²£¥Í³Ì¤jµ´¹ï­Èªº[­ì¨Ó¼Æ¦r

µM«á¤~·|¦³#10¼Ó¼Ó¥D¦^ªº
·íªì¬O§Úªºµ§»~¡A³y¦¨¤j®aªº»~¸Ñ¤F

^ ^......(­ì¨Óªº¼Æ¦r­Y¬O­n¥X²{"-19"...±zªºABS´N·|³£¬O"+"ªº..¤£·|¦³"-"ªº°Õ....)
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 12# PD961A
§Ú¬O¤£¤F¸Ñ,¥i²£¥Í³Ì¤jµ´¹ï­Èªº¼Æ¦r,»P §ä¥X³Ì¤jªºµ´¹ï­È ¦³¦ó¤£¤@¼Ë?
µ´¹ï­Èªº¼Æ³£¬O¥¿¼Æ »P­ì¥»¼Æ¦rªº¥¿­tµLÃö
19,-19 ¨â¼Æªºµ´¹ï­È³£¬O19

TOP

¦^´_ 11# GBKEE

ª©¥D:
    ¼Ó¥D°Ýªº°ÝÃD:¨Dµ´¹ï­È³Ì¤j¼Æ¡A¥¿¸Ñ¬O-19                        
                        
§ä¥X¥i²£¥Í³Ì¤jµ´¹ï­Èªº¼Æ¦r=-19(©Ò¥Hµª®×¥¿¸Ñ¬O-19)                        
¶È¬O­n§ä¥X³Ì¤jªºµ´¹ï­È=19(«h¬Oµ´¹ï­È«á²£¥Íªº³Ì¤j¼Æ=19)                        

©Ò¥H2­Óªº¤½¦¡´N·|¤£¤@¼Ë....

±z¦³§Oªº¤£¤@¼Ëªº·Qªk¶Ü?
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¼Ó¥Dªº­ì·N¬O­n§ä¥X¥i²£¥Í³Ì¤jµ´¹ï­Èªº¼Æ¦r¶Ü¡H
©ÎªÌ¶È¬O­n§ä¥X³Ì¤jªºµ´¹ï­È¡H   ³o¨âªÌ¦ü¥G¤£¤Ó¤@¼Ë..
toomellowhaw µoªí©ó 2010-10-27 23:21

toomellowhaw :¥i§_½Ð±Ð¤@¤U ¤£¤@¼Ë¦b­þ¸Ì??

TOP

·íªì¬O§Úªºµ§»~¡A³y¦¨¤j®aªº»~¸Ñ¤F
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¦]¬°±zªº­ì¤å..
  ¨Dµ´¹ï­È³Ì¤j¼Æ¡A¥¿¸Ñ¬O-19¡A¦pªG¤£¥Îvb
  À³¸Ó¦p¦ó¼g©O¡H

©Ò¥H..
¬Ý¨Ó¬O§Ú»~¸Ñ¤F¡A¥H¬°¬O­n§ä¥X¥i²£¥Í³Ì¤jµ´¹ï­Èªº[­ì¨Ó¼Æ¦r]

TOP

¼Ó¥Dªº­ì·N¬O­n§ä¥X¥i²£¥Í³Ì¤jµ´¹ï­Èªº¼Æ¦r¶Ü¡H
©ÎªÌ¶È¬O­n§ä¥X³Ì¤jªºµ´¹ï­È¡H
³o¨âªÌ¦ü¥G¤£¤Ó¤@¼Ë..
toomellowhaw µoªí©ó 2010-10-27 23:21

¨º½Ð°Ýtoomellowhaw¡A³o­Ó¨â§Aªº©w¸q¬O¤°»ò©O¡H
¥i¥H´£¥X¨ÓÅý¤j®a¤F¸Ñ¡A¤]³\©¹«á¦³¨ä¥L¤H¤]¦³¬Û¦PªººÃ°Ý

³o­Ó°ÝÃD¡A¤]¬O¦³ÂIÅý¤H·P¨ìºÃ´bªº¦a¤è
µ´¹ï­È³Ì¤j¼Æ¡A¥H¼Æ¾Ç¨Ó»¡ |18|  ¸ò |-19|
¥X¨Ó¬O18 ¸ò 19 §a ¡A©Ò¥Hµ´¹ï­È³Ì¤j¼ÆÀ³¸Ó¬O19¡A¦Ó¤£¬O-19§a
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¥»©«³Ì«á¥Ñ toomellowhaw ©ó 2010-10-27 23:33 ½s¿è

¼Ó¥Dªº­ì·N¬O­n§ä¥X¥i²£¥Í³Ì¤jµ´¹ï­Èªº¼Æ¦r¶Ü¡H
©ÎªÌ¶È¬O­n§ä¥X³Ì¤jªºµ´¹ï­È¡H
³o¨âªÌ¦ü¥G¤£¤Ó¤@¼Ë..

TOP

=MAX(ABS(MAX(A1:A3)),ABS(MIN(A1:A3)))

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD