ªð¦^¦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

Â^¨ú.PNG
2020-7-22 15:29

¦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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD