ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] µ¥¤ñ¯Å¼Æ¬Û¥[

[µo°Ý] µ¥¤ñ¯Å¼Æ¬Û¥[

¤j¤j­Ì¦n,
B2¬O°_©l­È¬°1,¨C¼W¥[¤@¼h´N¦h3­¿¡A
·íE2=2¥Nªí²Ä1¼h+²Ä2¼hªº­È=4
·íE2=3¥Nªí²Ä1¼h+²Ä2¼h+²Ä3¼hªº­È=13
¦p¦ó¦bE1 key¤J¼h¯Å®É¡A¥H¤½¦¡±a¥XE2ªº¼h¯Å¥[Á`¡H
¦ý¨ä±ø¥ó­­¨î¬O¥u¯à§Q¥ÎE1ªº­ÈÅܤơA¤£¯à¥ÎAÄæ¤ÎBÄ檺¼Æ¦r¥h¥[Á`©Î·j´M¡I
½Ð°Ý¦³¤°»ò¨ç¼Æ¥i¥H¥Î¡H

µ¥¤ñ¯Å¼Æ¬Û¥[.rar (6.47 KB)

2016-07-02_212157.jpg

¦^´_ 1# PJChen

   ¬Ý¬Ý³o­Ó¬O¤£¬O§A­nªº
   E2 =SUMPRODUCT(3^(ROW(INDIRECT("1:"&E1))-1))
   ©Î¬O¥ÎSUM+°}¦C¤½¦¡

   ­n§ó²±¶°ª®Äªº´N±oµ¥¨ä¥L¤H«üÂI¤F

TOP

¥»©«³Ì«á¥Ñ PJChen ©ó 2016-7-2 23:39 ½s¿è

¦^´_ 2# KCC

±z¦n,

¤Ó·PÁ±z¤F¡A¥i¥Hºâ¥X¥¿½Tµª®×¡I¥i§_À°¦£¸ÑÄÀ¤U¤½¦¡ªº·N¨ç¡H
=SUMPRODUCT(3^(ROW(INDIRECT("1:"&E1))-1))

¥t¥~¦A½Ð±Ð¡A­Y1·í¦¨²Ä0¼h®É¡A¤½¦¡¥i¥H«ç»ò§ï¡H¥Ø«eE1=0®É·|¥X²{#REF!
¼h¯Å ­Ó¼Æ
0        1
1        3
2        9
3        27
4        81
5        243
6        729
7        2187
8        6561

TOP

¦^´_ 3# PJChen

   1. §Q¥Î3^(row(1:x)-1)§@¥X {3^0,3^1......3^X},¦A¥[Á`
   2.SUMPRODUCT(3^(ROW(INDIRECT("1:"&E1+1))-1))

TOP

¦^´_ 4# KCC

ÁÂÁ±zªº¸Ñ»¡

TOP

¦^´_ 4# KCC

1. §Q¥Î3^(row(1:x)-1)§@¥X {3^0,3^1......3^X},¦A¥[Á`.....
2.SUMPRODUCT(3^(ROW(INDIRECT("1:"&E1+1))-1))

½Ð°Ý¤j¤j¡A
§Ú±q¬Q¤Ñ¤@ª½¦b¬ã¨s³o­Ó¤½¦¡¡AÁöµM±zÀ°§Ú§@¥X¨Ó¤F¡AÅý§Ú¥i¥Hª½±µ®M¥Î¡A¦ý§ÚÁÙµLªk¥þ³¡²z¸Ñ....
°ÝÃD¡G
1. ¬õ¦rªº³¡¥÷­n«ç»ò¥h²z¸Ñ·N¨ç¡HÁÙ¦³¬°¤°»ò­n§â¥¦·í§@¬O¤å¦r¡H(§Ú¬Ý¥¦¥Î¤FÂù¤Þ¸¹")
2. ³Ì¥~¼h¥Î¤FSUMPRODUCT¬°¤°»ò´N¯à°÷¦Û°Ê§@¥X {3^0,3^1......3^X},¦A¥[Á`.....

Sorry¡I³o¹ï§Ú¦³ÂI²`¡A³Â·Ð±z¤F...

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2016-7-3 17:57 ½s¿è

¦^´_ 6# PJChen


    ¤@¡B°ò¥»°}¦C»¡©ú
row(1:1)={1},row(1:2)={1;2}

={sum(row(1:2))}=sum({1;2})=3=sumproduct(row(1:2))
²Ä¤@­Ó¬O°}¦C¤½¦¡¡A­n«öctrl-shift-enter
´N¹³¼gvbaµ{¦¡¤@¼Ë¡Asum¨ç¼Æ+°}¦C¤½¦¡¥i¥H²³æ·Q¹³¶]°j°é§@²Ö¥[
¦Ósumproduct¥»¨­¨ã°}¦C¤½¦¡¯S©Ê¡A©Ò¥H¤£¥²¦A«öctrl-shift-enter
¤p¼Æ¦rok¡A¦pªG­n§@¥X1~100ªº°}¦C¡A¤£¥Î°}¦C¤½¦¡´N±o§Ë¥X{1;2;3....100}
¤]¥i¥H²³æªºrow(1:100)¡A°t¦X¨ä¥L¹Bºâ¨ç¼Æ¦A«öctrl-shift-enter
¦p{sum(row(1:100))}´N¥i¥H¥[Á`1~100

¤G¡B¤½¦¡»¡©ú
§Q¥Î3^(row(1:x)-1)§@¥X {3^0,3^1......3^X},¦A¥[Á`.....
³o­Ó§Ú¼g¿ù¤F¡AÀ³¸Ó¬O§@¥X {3^0;3^1......3^(X-1)},¦A¥[Á`.....
¹ê»Ú¤WÀ³¸Ó¥Î¤À¸¹¡A¥Nªírow¨ç¼Æ²£¥Íªº¼Æ¦C¬O««ª½°}¦C
¦ý¤@¯ë懒±o¥´³£¥´³r¸¹
x¬O·íÅܼơA³o¸Ì«üªº´N¬O§A¦b E1 ¿é¤Jªº­È¡A©Ò¥H¤½¦¡¬Oª½±µ¼ge1

3^(row(1:x)-1)
3^(row(1:1)-1)={3^(1-1)}={3^0}={1}
3^(row(1:2)-1)={3^(1-1);3^(2-1)}={1;3} ©³¤U¨Ì¦¹Ãþ±À
¦]¬°­nºâªº¬O¨ÌÅܼƪº­È¦ÓÅÜ°Ê
¦Ü©ó¥Î " ¡Aindirect¨ç¼Æ³£­n¥Î¤å¦r«¬¦¡¿é¤J ¤å¦r&e1 ÁÙ¬O¤å¦r
©Ò¥H§Q¥Î(indirect("1:"&E1)§@¥X(1:1)(1:2)..µ¥ªº°Ï°ìµ¹row¨ç¼Æ¨Ó¤Þ¥Î¨D­È

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD