???? ID: 182189 - ????? ???????: 14 ??????? 2011 - ??????: 5.0

Excel ??? ????????? ?? ?????? ?? ??? ??? ????? ?????? ????? ?? ??? ???? ????

?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

Microsoft Excel ??? ??? ???? ??? ????? ???? ???? ?? ?????? ?? ?????? ?? ??????? ?? ?????? ??? ???? ???? ??? ????????? ???? ???? ????

???? ???????

Excel ?? ????????? ??? ?? Microsoft Excel 97 ?? ?????? ???, ?? ?? ???? ???? ?? ????? ?????? ???? ??? ??? ?? ?? ?? ?????? ??? ?? ?????? ?? ??? ??? ????? ????? ?????? ????? ?? ????

?????? ?? ???, #DIV/0! ??? A1 ???? ?? ??? ???? ?????????? ??? ????? ???? ???? ????:
   A1: =B1/C1   B1: 5   C1: 0
				
?????? ??? ?? ?????? ?? ??? ?? ????? ????? ?? ??? ??? A1 ??? ????? ??? ???? ???:
=IF(ISERROR(B1/C1),"",B1/C1)
?? ???????? ??? ?? ????? ???? ????? ???????? ("")?

Microsoft Office Excel 2007 ???, ?? ?? ????? ?? ???? ???IFERROR?? ????? ?? ?? ??? ??? ??? ????? ???? ?? ??? ????? ????:
=IFERROR(B1/C1,"")
????? ??? ?? ??? ???? ??????? ?? Excel ?? ????????? ??? Excel 97 ?? ?????? ??? ?? ????? ?? ???? ??? ?? ?????? ??? ???? ?? ??? ???

????? ??????? ??? A1 ??? ???? ?? ????? ?? ????? ???? ?? ??? ?? ??? A1 ??? appearing ?? ?????? ??? ?? ????? ???? ?? ?????? ???? ???

?????? ??? ?????? ??? ??????? ?????? ??? ?? ??? ?? ?????? ?? ??? ????? ??????? ?? ????? ????, ?????? ???? ?? ??? Excel ?? ??????? ?? ??? ??????? ?? ??? ???, ????? ????? ???????????? ??? ?? ?? ?? ??????

Microsoft Office Excel 2003 ?? Excel ?? ????? ???????

  1. ???? ?????????? ??? ????? ???? ???? ????:
       A1: =B1/C1           B1: 5   C1: 0
       A2: =nofunction()*B2   B2: 6   C2: 0
    						
    ???:???? A1 ???? #DIV/0! ?????? ??? ?? ??? A2 #NAME ???? ??? ?????? ???? ?? ?? ???? ?? ???????nofunction()??? A2 ??? ????? ???? ???? ?? ?? ?????? ????? ?????? ??? ???? ???
  2. A. ????? ?? ??? ????
  3. ????? ?????????????? ??,Conditional ???????.
  4. ?????Conditional ???????????? ????? ???, ????? ?????????? 1?? ????-????? ????, ?? ???? ???????? ??.
  5. ?????? ????? ?? ???? ???????? 1, ????? ????? ???? ????:
    =ISERROR(A1)
  6. ????? ????????????? ??? ??????????? ????????? ????? ???, ????? ???????????? ????, ?? ???? ?????????????
  7. ????? ????,OK??????????? ????????? ????? ??? ??? ????? ?? ???? ????, ?? ???? ???OK?????Conditional ???????????? ????? ?? ??????? ?? ??? ?? ..

    ???:??????? ???? ?????? ????? ????? A ??? ??? 2, ??? ?????? ??? ????? A ?? ????? ?????? ?? ???????? ??? ?????, ??? ?? ???? ???? ????? A ??? ?????? ??? ?? ???? ???? ???? ?????? ??? ?? ???? ????????? ??????

Microsoft Office Excel 2007

  1. ???? ?????????? ??? ????? ???? ???? ????:
       A1: =B1/C1           B1: 5   C1: 0
       A2: =nofunction()*B2   B2: 6   C2: 0
    						
    ???:???? A1 ???? #DIV/0! ?????? ??? ?? ??? A2 #NAME ???? ??? ?????? ???? ?? ?? ???? ?? ???????nofunction()??? A2 ??? ????? ???? ???? ?? ?? ?????? ????? ?????? ??? ???? ???
  2. A. ????? ?? ??? ????
  3. ????? ????????? ???????? ??, ??? ?? ??? ??? ????? ????Conditional ???????????????????????, ?? ???? ?????? ????.
  4. ???????? ???? ???????????? ????? ???, ????? ??????? ?????? ?? ???????? ???? ?? ??? ?? ????????? ???? ?? ??? ???? ????? ?? ????? ????.
  5. ????????? ????? ??????? ????????? ???, ????? ????? ???? ???????? ?? ????? ???? ?? ????? ?? ???????? ?????????:
    =ISERROR(A1)
  6. ????? ????????????? ???
  7. ??????????? ????????? ????? ???, ????? ????????????, ?? ???? ??? ????? ???????????? square??????? ????
  8. ????? ????,OK?? ????-????? ????, ?? ???? ???OK???????? ???? ???????????? ????? ?? ??????? ?? ??? ?? ..

    ???:??????? ???? ?????? ????? ????? A ??? ??? 2, ??? ?????? ??? ????? A ?? ????? ?????? ?? ???????? ??? ?????, ??? ?? ???? ???? ????? A ??? ?????? ??? ?? ???? ???? ???? ?????? ??? ?? ???? ????????? ??????

???? ???? ???? ??:
  • Microsoft Office Excel 2007
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
??????: 
kbhowto kbmt KB182189 KbMthi
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:182189  (http://support.microsoft.com/kb/182189/en-us/ )