¾³£Ê¹ÓÃExcelµÄÅóÓÑ¿ÉÄܶ¼»áÓöµ½Ò»Ð©¿´ÆðÀ´Ëƶ®·Ç¶®µÄ´íÎóÖµÐÅÏ¢£ºÀýÈç# N/A£¡¡¢#VALUE£¡¡¢#DIV/O£¡µÈµÈ£¬³öÏÖÕâЩ´íÎóµÄÔÒòÓкܶàÖÖ£¬ÄãÕæµÄÁ˽âËüÃÇÂð£¬ÊìÁ·ÕÆÎÕ½â¾öÕâЩ´íÎóµÄ·½·¨Âð£¿ÒÔÏÂΪ´ó¼Ò½éÉܼ¸ÖÖ³£¼ûµÄ´íÎó¼°Æä½â¾ö·½·¨£¬
Á˽â°ËÖÖExcel¹«Ê½µÄ´íÎóÖµµÄ½â¾ö·½·¨EXCEL»ù±¾½Ì³Ì
¡£1£®#####£¡
Èç¹ûµ¥Ôª¸ñËùº¬µÄÊý×Ö¡¢ÈÕÆÚ»òʱ¼ä±Èµ¥Ôª¸ñ¿í£¬»òÕßµ¥Ôª¸ñµÄÈÕÆÚʱ¼ä¹«Ê½²úÉúÁËÒ»¸ö¸ºÖµ£¬¾Í»á²úÉú#####£¡¡£Õâ¸ö¿´ÆðÀ´±È½Ï¼òµ¥£¬´ó¼ÒÓ¦¸Ã¶¼Á˽â°É¡£
½â¾ö·½·¨£ºÈç¹ûµ¥Ôª¸ñËùº¬µÄÊý×Ö¡¢ÈÕÆÚ»òʱ¼ä±Èµ¥Ôª¸ñ¿í£¬¿ÉÒÔͨ¹ýÍ϶¯ÁбíÖ®¼äµÄ¿í¶ÈÀ´ÐÞ¸ÄÁÐ¿í¡£Èç¹ûʹÓõÄÊÇ1900ÄêµÄÈÕÆÚϵͳ£¬ÄÇôExcelÖеÄÈÕÆÚºÍʱ¼ä±ØÐëΪÕýÖµ¡£Èç¹û¹«Ê½ÕýÈ·£¬Ò²¿ÉÒÔ½«µ¥Ôª¸ñµÄ¸ñʽ¸ÄΪ·ÇÈÕÆÚºÍʱ¼äÐÍÀ´ÏÔʾ¸ÃÖµ¡£(ͼ1)
ͼ1
2£®#VALUE!
µ±Ê¹ÓôíÎóµÄ²ÎÊý»òÔËËã¶ÔÏóÀàÐÍʱ£¬»òÕßµ±¹«Ê½×Ô¶¯¸üÕý¹¦Äܲ»ÄܸüÕý¹«Ê½Ê±£¬½«²úÉú´íÎóÖµ#VALUE!¡£ÕâÆäÖÐÖ÷Òª°üÀ¨3µãÔÒò¡£
1£©ÔÚÐèÒªÊý×Ö»òÂ߼ֵʱÊäÈëÁËÎı¾£¬Excel²»Äܽ«Îı¾×ª»»ÎªÕýÈ·µÄÊý¾ÝÀàÐÍ¡£
½â¾ö·½·¨£ºÈ·ÈϹ«Ê½»òº¯ÊýËùÐèµÄÔËËã·û»ò²ÎÊýÕýÈ·£¬²¢ÇÒ¹«Ê½ÒýÓõĵ¥Ôª¸ñÖаüº¬ÓÐЧµÄÊýÖµ¡£ÀýÈ磺Èç¹ûµ¥Ôª¸ñA1°üº¬Ò»¸öÊý×Ö£¬µ¥Ôª¸ñA2°üº¬Îı¾£¬Ôò¹«Ê½="A1+A2"½«·µ»Ø´íÎóÖµ#VALUE!¡£¿ÉÒÔÓÃSUM¹¤×÷±íº¯Êý½«ÕâÁ½¸öÖµÏà¼Ó£¨SUMº¯ÊýºöÂÔÎı¾£©£º=SUM£¨A1:A2£©¡££¨Í¼2£©
ͼ1
2£©½«µ¥Ôª¸ñÒýÓᢹ«Ê½»òº¯Êý×÷ΪÊý×é³£Á¿ÊäÈë¡£
½â¾ö·½·¨£ºÈ·ÈÏÊý×é³£Á¿²»Êǵ¥Ôª¸ñÒýÓᢹ«Ê½»òº¯Êý¡£
3£©¸³ÓèÐèÒªµ¥Ò»ÊýÖµµÄÔËËã·û»òº¯ÊýÒ»¸öÊýÖµÇøÓò¡£
½â¾ö·½·¨£º½«ÊýÖµÇøÓò¸ÄΪµ¥Ò»ÊýÖµ¡£ÐÞ¸ÄÊýÖµÇøÓò£¬Ê¹Æä°üº¬¹«Ê½ËùÔÚµÄÊý¾ÝÐлòÁС£
3£®#DIV/O!
µ±¹«Ê½±»Áã³ýʱ£¬½«»á²úÉú´íÎóÖµ#DIV/O!¡£ÔÚ¾ßÌå²Ù×÷ÖÐÖ÷Òª±íÏÖΪÒÔÏÂÁ½ÖÖÔÒò¡£
1£©ÔÚ¹«Ê½ÖУ¬³ýÊýʹÓÃÁËÖ¸Ïò¿Õµ¥Ôª¸ñ»ò°üº¬ÁãÖµµ¥Ôª¸ñµÄµ¥Ôª¸ñÒýÓã¨ÔÚExcelÖÐÈç¹ûÔËËã¶ÔÏóÊÇ¿Õ°×µ¥Ôª¸ñ£¬Excel½«´Ë¿ÕÖµµ±×÷ÁãÖµ£©¡£
½â¾ö·½·¨£ºÐ޸ĵ¥Ôª¸ñÒýÓ㬻òÕßÔÚÓÃ×÷³ýÊýµÄµ¥Ôª¸ñÖÐÊäÈ벻ΪÁãµÄÖµ¡£
2£©ÊäÈëµÄ¹«Ê½Öаüº¬Ã÷ÏԵijýÊýÁ㣬ÀýÈ磺¹«Ê½=1/0¡£
½â¾ö·½·¨£º½«Áã¸ÄΪ·ÇÁãÖµ£¬
µçÄÔ×ÊÁÏ
¡¶Á˽â°ËÖÖExcel¹«Ê½µÄ´íÎóÖµµÄ½â¾ö·½·¨EXCEL»ù±¾½Ì³Ì¡·(https://www.unjs.com)¡£5£®#N/A
µ±ÔÚº¯Êý»ò¹«Ê½ÖÐûÓпÉÓÃÊýֵʱ£¬½«²úÉú´íÎóÖµ#N/A¡£
½â¾ö·½·¨£ºÈç¹û¹¤×÷±íÖÐijЩµ¥Ôª¸ñÔÝʱûÓÐÊýÖµ£¬ÇëÔÚÕâЩµ¥Ôª¸ñÖÐÊäÈë"#N/A"£¬¹«Ê½ÔÚÒýÓÃÕâЩµ¥Ôª¸ñʱ£¬½«²»½øÐÐÊýÖµ¼ÆË㣬¶øÊÇ·µ»Ø#N/A¡£
6£®#REF!
ɾ³ýÁËÓÉÆäËû¹«Ê½ÒýÓõĵ¥Ôª¸ñ£¬»ò½«Òƶ¯µ¥Ôª¸ñÕ³Ìùµ½ÓÉÆäËû¹«Ê½ÒýÓõĵ¥Ôª¸ñÖС£µ±µ¥Ôª¸ñÒýÓÃÎÞЧʱ½«²úÉú´íÎóÖµ#REF£¡¡£
½â¾ö·½·¨£º¸ü¸Ä¹«Ê½»òÕßÔÚɾ³ý»òÕ³Ìùµ¥Ôª¸ñÖ®ºó£¬Á¢¼´µ¥»÷"³·Ïû"°´Å¥£¬ÒÔ»Ö¸´¹¤×÷±íÖеĵ¥Ôª¸ñ¡£
7£®#NUM£¡
µ±¹«Ê½»òº¯ÊýÖÐij¸öÊý×ÖÓÐÎÊÌâʱ½«²úÉú´íÎóÖµ#NUM£¡¡£
1£©ÔÚÐèÒªÊý×Ö²ÎÊýµÄº¯ÊýÖÐʹÓÃÁ˲»ÄܽÓÊܵIJÎÊý¡£
½â¾ö·½·¨£ºÈ·ÈϺ¯ÊýÖÐʹÓõIJÎÊýÀàÐÍÕýÈ·ÎÞÎó¡£
2£©Óɹ«Ê½²úÉúµÄÊý×ÖÌ«´ó»ò̫С£¬Excel²»Äܱíʾ¡£
½â¾ö·½·¨£ºÐ޸Ĺ«Ê½£¬Ê¹Æä½á¹ûÔÚÓÐЧÊý×Ö·¶Î§Ö®¼ä¡£
8£®#NULL£¡
ʹÓÃÁ˲»ÕýÈ·µÄÇøÓòÔËËã·û»ò²»ÕýÈ·µÄµ¥Ôª¸ñÒýÓᣵ±ÊÔͼΪÁ½¸ö²¢²»ÏཻµÄÇøÓòÖ¸¶¨½»²æµãʱ½«²úÉú´íÎóÖµ#NULL£¡¡£
½â¾ö·½·¨£ºÈç¹ûÒªÒýÓÃÁ½¸ö²»ÏཻµÄÇøÓò£¬ÇëʹÓÃÁªºÏÔËËã·û¶ººÅ£¨£¬£©¡£¹«Ê½Òª¶ÔÁ½¸öÇøÓòÇóºÍ£¬ÇëÈ·ÈÏÔÚÒýÓÃÕâÁ½¸öÇøÓòʱ£¬Ê¹ÓöººÅ¡££¨Í¼3£©Èç¹ûûÓÐʹÓöººÅ£¬Excel½«ÊÔͼ¶ÔͬʱÊôÓÚÁ½¸öÇøÓòµÄµ¥Ôª¸ñÇóºÍ£¬ÓÉÓÚA1:A13ºÍc1
¹Ø ¼ü ×Ö£ºEXCEL
Ïà¹ØÎÄÕ£º
Excel ¼ÓÃÜÎļþ
Excel¡°¹«Ê½ÇóÖµ¡±¹¦ÄÜ
Excel±êÌâ¿çÁоÓÖÐ
Excel±í¸ñ±ß¿òÉèÖÃ
Excel±í¸ñ±êÌâÖظ´´òÓ¡
2:c23²¢²»Ïཻ£¬ËüÃÇûÓй²Í¬µÄµ¥Ôª¸ñËùÒԾͻá³ö´í¡£
ͼ3
¹Ø ¼ü ×Ö£ºEXCEL
Ïà¹ØÎÄÕ£º
Excel ¼ÓÃÜÎļþ
Excel¡°¹«Ê½ÇóÖµ¡±¹¦ÄÜ
Excel±êÌâ¿çÁоÓÖÐ
Excel±í¸ñ±ß¿òÉèÖÃ
Excel±í¸ñ±êÌâÖظ´´òÓ¡