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

[µo°Ý] °µ­¼¼Æ¤£­n$L31*$M31 ¤£­nVALUE

°µ­¼¤£­nNA#

=$L31*$M31


¦pªG¨ä¤¤¤@­Ó¼Æ¬OªÅ¤F·|¥X²{NA «ç¼Ë¥ONA#¥¢¥h

TOP

[µo°Ý] °µ­¼¼Æ¤£­n$L31*$M31 ¤£­nVALUE

°µ­¼¼Æ¤£­n$L31*$M31  ¤£­nVALUE

¦^´_ 1# ­â¼C
¥|«h¹Bºâ·|²£¥Í¿ù»~­Èªº­ì¦]¡A¤£¥~¥G¬OÀx¦s®æ¤º§t¦³¤å¦r«¬ºAªº¸ê®Æ
¦Ü©ó­nÁ׶}¿ù»~­ÈÅã¥Ü¡A¨Ï¥ÎIS¨ç¼Æ¨Ó°µIF¨ç¼Æªº§PÂ_¦¡¡A§Y¥iÁקKÅã¥Ü¿ù»~­È
¨Ò¦p:
=IF(ISNUMBER(A1*B1),A1*B1,"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD