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

½Ð°ÝªÅ­È­¼¤W¼Æ¦r¥X²{#VALUE!

½Ð°ÝªÅ­È­¼¤W¼Æ¦r¥X²{#VALUE!

¥»©«³Ì«á¥Ñ gaishutsusuru ©ó 2020-7-22 15:33 ½s¿è

¦U¦ì¤j¤j±z¦n¡A


¦p¹Ï¡A¸Ì­±¤À§O¬O¡õ
A1¡GªÅ¥Õ
B1¡G=IF(A1="","")
C1¡G3
D1¡G=B1*C1

B1Ū¥X¨Óªº­ÈÀ³¸Ó¬O0¡A©Ò¥H0*3À³¸Óµ¥©ó0¡A¦ý¬°¤°»òD1·|¥X²{#VALUE#©O?

½Ð°ÝÀ³¸Ó¦p¦ó¤~¯àÅýD1ªº­È¬O0©O?


¦A½Ð¤j®a©âªÅ´£¨Ñ·Qªk¡AÁÂÁ¤j®a¡C

=N(B1)*N(C1)

TOP

¦^´_ 2# ­ã´£³¡ªL

ÁÂÁ­㴣¤j¤j¡A·PÁ±zªºÀ°¦£¡C

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD