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

[µo°Ý] ¨Dµ´¹ï³Ì¤j¡B³Ì¤p­È

[µo°Ý] ¨Dµ´¹ï³Ì¤j¡B³Ì¤p­È

AÄ欰­ì©l¼Æ¾Ú, ¬O§_¯àª½±µ¨D¥X¸ÓÄæ¦ìµ´¹ï­È(ABS)¤ºªº³Ì¤j­È(MAX)¤Î³Ì¤p­È(MIN)
2017-03-27_162532.jpg

{=MAX(ABS(A1:A20))}
{=Min(ABS(A1:A20))}
ù

TOP

ÁÂÁ rouber590324 ¸Ñµª
¦pªG­ì©l¼Æ¾Ú¤¤¦³ªÅ®æ, ¨D¥Xªº­È¬O#value, ­n¦p¦ó²¤¹LªÅªº¼Æ¾Ú©O

TOP

C3 =MAX(MAX(A:A),-MIN(A:A))
D3 =MIN(ABS(LARGE(A:A,COUNTIF(A:A,">=0")+{0,1})))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    ÁÂÁ¸ѵª :)

TOP

¦^´_ 4# ML089


   
2017-04-18_131740.jpg
2017-4-18 13:18


     ¦A½Ð±Ð¦p¦ó­pºâCÄæ-BÄæ«áµ²ªG³Ì¤p­È¡B³Ì¤j­È¡B¥­§¡­È

TOP

¦p¤U
{=MIN(C1:C20-B1:B20)}
{=MAX(C1:C20-B1:B20)}
{=AVERAGE(C1:C20-B1:B20)}
ù

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD