????? ?? Microsoft Excel ??? ??-????? ???? ???????? ?? ????? ???? ????

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

??????

?? ???? ????? ???? ?? ?? ????? ?? ??? ?? Microsoft Excel ??? ??-????? ???????? ?? ????? ???? ????? ?? ???????? ???? ?? ?? ??? ???????? ?? ????? ???????? ?? ??????? ???? ?? ?????? ???

???? ???????

?? ?? ?? ??-????? ???? ????? ???, ?? ?? ????? ???? ????????? ?????????? ????? ????, ??????? ????? ????boxes??????????? ????? ?? ??????? ?? ??? ?? ..

???:??? 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 substitutes) ??, ?? A15 ?????? ????? ???? ?? (?? 6, 7, 8, 9 ?? 10 ??? substitutes) ??? ?? ????? ????????????????; ???? ????? ?? ???? ?? ?? ?? ???? ???? ?? ???? ??? ??????? ?? ?????? ??? ?? ?? ???? B14:G19 ???, ?? A14 ?? A15 ?????? ?? ???? ???, ??????? ?? ????? ????? ????? ?? ?????? ????? ???? ????
  5. B14:G19 ?? ??? ?????
  6. ????? ????????:???? ??,??????.

    ???:Excel 2007 ???, ????? ????????:??? ??,What-??? ?? ???????? ?????? ????-????? ????, ?? ???? ??????? ??????.
  7. ??????????? ????? ????????? ???,?15:. ?????????? ????? ????????? ???,?14:.
  8. ????? ????,OK.
?? ????? ?????? ?????:
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 ???? ?? ????? internally ?????? ?? ????? ????? ???? ??? ??? substitutes.

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

??????

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

???

???? ID: 282856 - ????? ???????: 20 ??????? 2011 - ??????: 3.0
???? ???? ???? ??:
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 97 Standard Edition
??????: 
kbexpertisebeginner kbhowto kbmt KB282856 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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