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

?????? ????????? ?????? ?????????
???? ???????: 214143 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ????? ??????? ?????? INDIRECT ??? ??? ?????? ?? ???? ?? Microsoft Excel 2000 ????????.

????? ??????? ?????? ??? ?????

?????? ???? ????? ????? ?? ??? ???? ?? ????? ?? ????? ? ?????? ???? ???? ????? INDIRECT. ??? ???? ??????? ??? ???? ?? ???? Excel ?????? ???? ?????? A1 ?????? ?????? ???????:
=indirect("$a$1")
???????? ???? ???? ????? INDIRECT ???? ??????? ???????:
  1. ??? ????? Excel ?? ?? ???? ???? ????.
  2. ????? ???? ????? ???????:
    ?1: 2
    a2: 3
    ?3: 4
    ?4: 5
    a5: 6
    a6: 7
    a7: 8
    a8: 9
    a9: 10
    a10: 11
  3. ???? ?????? ??????? ?? ?????? B1:
    =SUM(INDIRECT("$A$1:$A$10"))
    ???? ?????? 65.
  4. ??? ?????? A7.
  5. ?? ??????? ????? ? ???? ??? ????.

    ???? ?????? ?? ?????? B1 ???? 54 ??? ????? ????? ??????.

????? ????? ????

???? ??? ????? ????? ?? ???? ??????? ??????? ????? ??? ?? ??????? ???? ???? ??? ?? ?????? INDIRECT.

?????? ??? ???? ?? Excel ????? ??? ?????? ?? ??????? ????? ??? ???? ????? ?? ??????? ?? ?????? ????? ?????? ?? ??????? ???? ????. ???? ???? ??? ??? ????? ?? ??? ?? ?? ???? ???? ??? ??? ?????? ???? ??? ?????? ??? ?????? ????? ?????? ?????? ??????.

??? ???? ??????? ??? ??? ?????? ?????? 10 ?? ?????? A1 ?????? ???? ?? ???? B1 ????? ??????
= $ A $ 1
???? ?????? 10 ?? ?????? B1. ??? ??? ?????? ?? ?? ??? ?????? A1 ???? ??? ??? ?????? 10 ??? ?????? A2 ????? ?????? ?? ?????? B1 ??? ?? ???:
= $ $ 2

?????

????? ?? ????????? ??? ???? ???? ????? INDIRECT ???? ??? ??????? Microsoft Excel ?? ??????? ??????? ? ???? ??? ????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

???????

???? ???????: 214143 - ????? ??? ??????: 05/????/1428 - ??????: 4.2
????? ???
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
????? ??????: 
kbmt kbhowtomaster KB214143 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????214143

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com