???? ID: 214244 - ????? ???????: 20 ??????? 2011 - ??????: 3.0

XL: ???? ????? ???? ?? ??? ?? ????????? ???? ?? ??? ??? ????? ?????

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????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 ???, ?? ?? ?? ????? ??? ?? ???, ??? ????? ?? ????? tests ?? ????? ?? ??? ???? ??? ????????? ?????? ???? ???? ??? Microsoft Excel interprets ???? ????? ???? ?? ????? ?? ??? ???, ?? ????? ?? ????? ??? ??? ????? ?????, ????? ??? ?? ???? ???? ??? ?????? ????? ?? ??? ??? ?????????? ????

???? ???????

??? ???? ???? ?? ????? ??? ?? ??? ???? ???? ?? ???? ????? ??, ?? ??????? ???? ?? ??? ??? ????????? ???? ??? ?????? ?? ???, ??? ???? ??? ????? ????? ??? ???? A1
=IF(B1=0,"zero","blank")
?? ?? B1 ????? ??, "?????" ?? ???? "?????" ?? ??? ??? ???????? ????? ???? ???

?????? ???? ????? ???? ??? ?? ???? ??, ??? ?? ?? ????? ??? ?? ???, ????? ?????? ??? ?? ??? ??? ??????? ???? ?? ??? ISBLANK ?????? ????? ???? ?????:
=IF(ISBLANK(B2),"blank",IF(B2=0,"zero","other"))
????? ??? ?? ??????? ????? ???? "?????" ??? ????, "?????" ??? ???? ????? ???? ?? "????" ??? ???? ??? ?? ?? ??? ??? ?? ????? ??? ???

?? ????? ????? ???? ????? ISBLANK ????? ???? ????? ??? ?? ??? ???? ???? ?? ????? ?????? ?? ???? ????? ?? "????" ????? ??? ?? ??? ???? ?????, ?? ISBLANK ????? ?? ??? ??????? ???? ?? ??? ??? ? ??????? ?????
???? ???? ???? ??:
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
????? ?? ???? ????
??????: 
kbhowto kbmt KB214244 KbMthi
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:214244  (http://support.microsoft.com/kb/214244/en-us/ )
????? ?? ???? ????