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

?????? ????????? ?????? ?????????
???? ???????: 282856 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? ??? ??????? ????? ????? ?????? ??????? ????? ??????? ?? Microsoft Excel. ???? ??? ??????? ?????? ??? ???? ????????? ?? ??????? ????? ??? ???? ?????.

??????? ????

??? ????? ???? ????? ????? ????? ????? ??????? ?? ???????? ???? ????? ???? "?" ?????? ???? ??????? ?? ???? ?????? ????.

?????? ?? Microsoft Office Excel 2007 ???? ???? ?????? ???? ???? ?????? ???? ????????.

?????? ???? ????? ????? ???? ???? ??????? ???????:
  1. ????? ???? ????.
  2. B15: B19 ??????? ???? ???????? ???????:
         Cell       Value
         ----------------
         B15          1   
         B16          2
         B17          3
         B18          4
         B19          5
    					
  3. C14:G14 ??????? ???? ???????? ???????:
         Cell       Value
         ----------------
         C14          6   
         D14          7
         E14          8
         F14          9
         G14         10 
    					
  4. ?? ?????? B14 ???? ?????? ???????:
    = A14 * 2 + A15
    ??????: A14 ???? ????? ?????? (???? ??????? ??? 1, 2, 3 ? 4 ? 5) ? ??? A15 ???? ????? ???? (???? ??????? ??? 6 ? 7 8 9 ? 10). ????? ??????? ??? ??? ?? ???? ??????? ???? ??????; ?????? ?? ?? ?? ?? ????? ??? ??????. ???? ??? ????? ??? ?????? ?? B14:G19 ??????? ? ??? A14 ? A15 ???? ?????? ??? ?????? ???? ????? ??????? ??????? ???????.
  5. ??? B14:G19.
  6. ??? ??????? ?????? ? ???? ??? ????.

    ?????? ?? Excel 2007? ???? ??? ????? ??????? ?????? ? ???? ??? ????? What-If ?? ???? ??? ???? ??????.
  7. ?? ?????? ???? ????? ???? ? ???? A15. ?? ?????? ???? ????? ?????? ? ???? A14.
  8. ???? ??? ?????.
???? ??????? ???????:
Two-Input table (with formulas displayed)
=========================================

NOTE: Due to screen display limitations, the following six-column 
table is shown in two parts.

(Left three columns of a six-column table)

      |      B    |        C      |       D
   ---|-----------|---------------|---------------
    14| =A14*2+A15|              6|             7
    15|          1|=TABLE(A15,A14)|=TABLE(A15,A14)
    16|          2|=TABLE(A15,A14)|=TABLE(A15,A14)
    17|          3|=TABLE(A15,A14)|=TABLE(A15,A14)
    18|          4|=TABLE(A15,A14)|=TABLE(A15,A14)
    19|          5|=TABLE(A15,A14)|=TABLE(A15,A14)

(Right three columns of a six-column table.)

      |        E       |       F       |       G
   ---|----------------|---------------|---------------
    14|              8 |              9|             10
    15| =TABLE(A15,A14)|=TABLE(A15,A14)|=TABLE(A15,A14)
    16| =TABLE(A15,A14)|=TABLE(A15,A14)|=TABLE(A15,A14)
    17| =TABLE(A15,A14)|=TABLE(A15,A14)|=TABLE(A15,A14)
    18| =TABLE(A15,A14)|=TABLE(A15,A14)|=TABLE(A15,A14)
    19| =TABLE(A15,A14)|=TABLE(A15,A14)|=TABLE(A15,A14)


Two-Input table (with values displayed)
=======================================

      | B | C | D | E | F | G |
   ---|---|---|---|---|---|---|
    14|   |  6|  7|  8|  9| 10|
    15|  1|  8|  9| 10| 11| 12|
    16|  2| 10| 11| 12| 13| 14|
    17|  3| 12| 13| 14| 15| 16|
    18|  4| 14| 15| 16| 17| 18|
    19|  5| 16| 17| 18| 19| 20|
				
??????: ?????? ??? C15 ?????. ????? ??????? ???? ??? ????????? ?? ?????? ?? B15: B19 ??????? (????? ???? ???????) ? C15:G14 ??????? (????? ?????? ???????). ????? ?????? ?? ????? ?? ??? 1 * 2 + 6 (?????? 8). ?????? Excel ??????? ????? ???????? ?? ????? ??????? ?????? ???????? ?? ?????? ?? ?????? B14.

???? 0 ?? ?????? B14 ? ??? ????? ?? ?? ?????? B14 ??? ????? ?????. ?????? ?????? ??????? ?? ?????? B14 ???? ??????? ???????:
  1. ???? ??? ?????? ?????? ??? ?????? B14 ??? ?? ???? ??? ????? ?????.
  2. ???? ??? ????? ??????? ???.
  3. ?? ??????? ??? ? ???? ??? ????.
  4. ?? ?????? ??? ? ???? "" (?????? ??????).
  5. ???? ??? ?????.

?????

?????? ??? ???? ?? ????????? ??? ????? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
282851????? ??????? ????? ?????? Microsoft Excel ?????? ????????? ?? ????? ??????
282852???? ???? ??? ????? ???????? ?? Microsoft Excel
282855????? ????? ????? ?????? ????? ???? ?????????? ?? Microsoft Excel

???????

???? ???????: 282856 - ????? ??? ??????: 13/?? ?????/1427 - ??????: 5.0
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 98 ?? Macintosh
  • Microsoft Excel 97 Standard Edition
????? ??????: 
kbmt kbexpertisebeginner kbhowto KB282856 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????282856

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

 

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