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

­­¨î¤£¯à¤j©ó5¦ì¼Æ

­­¨î¤£¯à¤j©ó5¦ì¼Æ

=IF(ISERROR($AB$63*$X$72),"",$AB$63*$X$72)

½Ð°Ý
¥i­ø¥i¥Hµª®×¤£¯à¤j©ó5¦ì¼Æ,§Y³Ì¤j¥u¥i99999,

¦^´_ 1# bully

    =IF(ISERROR($AB$63*$X$72),"",if($AB$63*$X$72>=100000,99999,$AB$63*$X$72))
     ¦h¤@­ÓIF§PÂ_¦¡´N¥i¥H¤F
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

±µ¦¬¤F¡B·PÁ¤j¤j!!

TOP

¦^´_ 1# bully

¨Ï¥Î¼Æ¾Ç¨ç¼Æ MIN
=IF(ISERROR($AB$63*$X$72),"",MIN(9999,$AB$63*$X$72))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089
:handshake ¦hÁ¦U¦ì¤j¤j!

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD