- ©«¤l
- 178
- ¥DÃD
- 53
- ºëµØ
- 0
- ¿n¤À
- 242
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-2-22
- ³Ì«áµn¿ý
- 2024-7-5
|
¦^´_ 1# jsleee
Microsoft Office Excel µLªk±N¤å¦rÂà´«¦¨¥¿½Tªº¸ê®ÆÃþ«¬¡C½Ð½T©w¹ï©ó¥²nªº¹Bºâ¤¸©Î¤Þ¼Æ¦Ó¨¥¡A¤½¦¡©Î¨ç¼Æ¬O¥¿½Tªº¡A¦Ó¥B¤½¦¡©Ò°Ñ·ÓªºÀx¦s®æ¤¤¥]§t¦³®ÄªºÈ¡C¨Ò¦p¡A¦pªGÀx¦s®æ A5 ¥]§t¼Æ¦r¡A¦ÓÀx¦s®æ A6 ¥]§t¤å¦r¡u¤£¾A¥Î¡v¡A«h¤½¦¡ =A5+A6 ·|¶Ç¦^¿ù»~ #VALUE!¡C
¦pªG¤£·Q¬Ý¨ì¿ù»~°T®§¡A¥i¥H§Q¥ÎIFERROR(2007¥H¤W¤~¦³)¡A¥h±¼¿ù»~°T®§!
=IFERROR((VALUE(A1)),"0") |
|