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

[µo°Ý] ½Ð°Ý¦p¦ó³]©w­pºâ«á³Ì¤jªºÅã¥Ü­È

[µo°Ý] ½Ð°Ý¦p¦ó³]©w­pºâ«á³Ì¤jªºÅã¥Ü­È

¦U¦ì¥ý¶i¤j®a¦n~

·Q½Ð°Ý¤@­Ó°ÝÃD~

EXCEL¤ñ¦p17-1=16

¦p¦ó§â¥¦³]©wÅã¥Ü¬°8

¤S¨Ò¦p1-17=-16

§â¥¦³]©wÅã¥Ü¬°-8

­n¥Î¬Æ»ò¿ìªk¤~¯à³]©wÅã¥Ü­È??

³Â·Ð¦U¦ì¤j¤j¤F~

=IF(A2<0,MAX(A2,-8),MIN(A2,8))
    OR
=MIN(SIGN(A2)*A2,8)*SIGN(A2)
A2­pºâ¦¡
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

·PÁÂhcm19522¤j¤j~

«D±`ÁÂÁ§A~

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD