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

[µo°Ý] IFªº§xÂZ

¦^´_ 21# PJChen

§c¡Kmin(number1,number2,...numberN)¡G¦^¶Çnumber1¦ÜnumberN¤§¤¤³Ì¤pªº­È
©Ò¥Hmin(5,¤@ªø¦ê¤½¦¡)´N·|¦^¶Ç5©M"¤@ªø¦ê¤½¦¡"¤§¤¤³Ì¤pªº­È¡A¤]´N¬O¤@ªø¦ê¤½¦¡¤ñ5¤pªº¸Ü´N¦^¶Ç¤@ªø¦ê¤½¦¡¡A¤ñ5¤jªº¸Ü´N¦^¶Ç5

TOP

¦^´_ 22# Bodhidharma

¤F¸Ñ!!  min + if ªº°t¦X,¯uªº¤ñ³æ¿W¥Îif ²¼ä¤S¦n¥Î!!  ÁÂÁÂ.

TOP

¦^´_ 7# p212

¦bexcelhome§ä¨ì¤@½g¬Û·í¸g¨åªºtext¨ç¼Æ¤¶²Ð¤å³¹
http://club.excelhome.net/forum.php?mod=viewthread&tid=331382
¤£¹L¸Ó½g¦³ÂI²`¡A¥i¯à±oÀR¤U¤ß¨Ó¦n¦n¬ã¨s
(¸Ü»¡§Ú¦Û¤v¤]¦b¬ã¨s¤¤¡K)

TOP

¦^´_ 21# PJChen

¤@¯ë¥i¥H¥Î¤ñ¸ûªk¨Ó¥[²` MIN(5, ¤½¦¡)
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 1) = 1
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 2) = 2
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 3) = 3
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 4) = 4
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 5) = 5
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 6) = 5
¤½¦¡ªº­È¬° 1®É¡AMIN(5, 7) = 5
...
³o¸ò¤½¦¡¦³¦h¤Ö IF(...,IF(... µLÃö¡A
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§Q¥ÎÀx¦s®æ¦¡¡A¯u¤Ó§®¤F¡F¾Ç²ß,·PÁÂ

TOP

¦^´_ 25# ML089

Noted, thanks.

TOP

¤S¾Ç¨ì¤@©Û,ÁÂÁ¤j¤j¤À¨É

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD