¨ä¥L¤u§@ªíªº¤½¦¡,°Ñ·Ó ¥D¤u§@ªí ÅܤÆ
- ©«¤l
- 26
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN T
- ³nÅ骩¥»
- WIN 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-4-25
- ³Ì«áµn¿ý
- 2018-12-25
|
¨ä¥L¤u§@ªíªº¤½¦¡,°Ñ·Ó ¥D¤u§@ªí ÅܤÆ
¤j¤j ±z¦n ...
½Ð°Ý ¦³¨S¦³ ¥i¯à «Ü¦hÓ§Oªº ¤u§@ªí ¨Ì·Ó ¥D¤u§@ªí ªºµ{¦¡ ¨Ó°µÅܤÆ
¦]¬° ³]©w¤F «Ü¦hÓ ¤u§@ªí¬¡¶Ã¯, ¨Ã¥B µ{¦¡ÁÙ¨S §Ë¦n , ¥Bn ±`±` §ó§ï ¤½¦¡ , ¥H¬d·Ó ÅܤƱ¡§Î ,(±`±`¤@ÂI¤pÅܤÆ, »Ýn ®ö¶O«Ü¦h®É¶¡ copy , µ²ªG ±o¨ìªºµª®× ¿ù»~)
½Ð°Ý ±z ¦³³oºØ ¤½¦¡¶Ü ?
¨Ò: ¥D¸ÕÅçµ{¦¡ B12 = 5
C12 = 8
D12 = 1
F5=B12+C12 (¨ä¥L ´X10Ó Ó§Oµ{¦¡ F5 ¤½¦¡ ¤]¦p¦¹ ³]©w, ¥u¬O B12, C12, D12 ªºÈ¤£¤@¼Ë)
¦pªG ¥D¸ÕÅçµ{¦¡ F5 §ï¦¨ F5=C12 + D12 ¨ä¥L¬¡¶¥»¤u§@ªí ¤]¨S¦³ ¥i¯à ª½±µÅÜ°Ê ¤½¦¡
ÁÂÁ ..... (¦]¬° n ´úÅç µ{¦¡µ²ªG , ¦pªG ®ÄªG¤£¦n ... n ¦^´_¦^¨Ó , ¤@¨Ó¤@¥h ±`±`ªá¤F ¦n¦h®É¶¡ , ¦³®ÉÔ ¤@ ¤G ¤T ¤Ñ°µ¥Õ¤u , ©Ò¥H ·Q½Ð±Ð¤@¤U ¦³¨S¦³ ³oÓ¥i¯à ) |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¥i¥H¨Ï¥Î INDIRECT ¨ç¼Æ¨Ó³B²z
¨Ò¦p
¥D¸ÕÅçµ{¦¡!A1 = "B12"
¥D¸ÕÅçµ{¦¡!A2 = "C12"
F5 =B12 + C12
¨ä¥L¬¡¶¥»¤u§@ªíªºF5¤½¦¡§ï¬°
F5=INDIRECT(¥D¸ÕÅçµ{¦¡!A1)+INDIRECT(¥D¸ÕÅçµ{¦¡!A2)
·ín¨Ï¥Î F5=C12 + D12 ®É¡A
¥un§ó§ï
¥D¸ÕÅçµ{¦¡!A1 = "C12"
¥D¸ÕÅçµ{¦¡!A2 = "D12" |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN T
- ³nÅ骩¥»
- WIN 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-4-25
- ³Ì«áµn¿ý
- 2018-12-25
|
|
|
|
|
|
|