The experience of digging up Laite coin
Publish: 2021-05-16 09:04:04
1. I graated from college and it took me a few hours to get there.
2. Why can't you dig when the miner hurts yourself
does the platform stop mining? Then change the platform
if it's the power of buying Leyte, it's probably a liar
it's better not to be a liar, otherwise you have no place to complain
bitcoin answers for you
does the platform stop mining? Then change the platform
if it's the power of buying Leyte, it's probably a liar
it's better not to be a liar, otherwise you have no place to complain
bitcoin answers for you
3. Preface: please make sure that you have a basic understanding of electronic money (especially cryptography money) before reading this article, and understand the basic knowledge of "POW workload proof mechanism", timestamp and block chain system, decentralization, etc., which will not be repeated here
bitcoin is rising wildly, and e-money has set off a wave of speculation. Light currency (LTC) soared more than ten times, reaching a high price of 300 yuan. At the same time, a large number of counterfeit coins appeared, and the increase was amazing. It's not unusual to see them rise several times a day. E-money market has shown a strong speculative, investment risk has emerged. But is bitcoin the only winner? Is there any other e-coin that can "" the miracle of bitcoin, or even surpass it
assuming the success of e-money in the future, some people say that we only need one e-money. If the number of bitcoin is limited, it's OK to use mbtc or smaller units to trade when the price is very high. Other electronic coins are repetitive and meaningless
let's see how bitcoin has changed from "meaningless behavior" to a successful case, and what experience can be summed up
firstly, based on the combination of private key and public key of electronic cryptocurrency, bitcoin creatively proposed the block chain mechanism, as well as the binding of mining (protecting the whole network) and currency issuance rewards. And the implementation of a constant total to create deflation expectations, difficulty automatic adjustment to ensure fairness, as well as competitive mining and competitive block branches, to maximize the protection of the interests of the holders and miners, to achieve a win-win situation
this mechanism mobilizes the enthusiasm of miners and forms a virtuous circle. BTC rises, calculating power rises, calculating power rises, BTC is more stable and has higher value, so as to promote the price to continue to rise. Until now, bitcoin has formed an indestructible block chain system, which is the most valuable part of the bitcoin system, ensuring the maximum security of bitcoin holders, as well as the decentralized network structure, ensuring the openness and fairness of the bitcoin world. Social capital has invested a lot in bitcoin, forming a whole instrial chain. This is the value created by bitcoin from scratch. Although there are speculative factors, to a certain extent, the market value of bitcoin reflects this value
BTC market value: http://blockchain.info/charts/market-cap
BTC calculation force: http://blockchain.info/charts/hash-rate
but does this mean that bitcoin must be the most successful, and it will forever occupy the market share of the whole e-money in the future without further improvement
next, I'll make a comparison with LTC. Instead of recommending buying LTC, I'll talk about whether LTC can solve some problems of BTC and whether it will cause some new troubles< First of all, BTC has the following problems:
1, long confirmation time
I casually selected the current mining records and found that the block confirmation time was too long. First of all, the BTC default 10 minutes out of the block, has been a relatively long time. For some deals, it's a time of impatience. And because the difficulty is already very high, the block time is further uneven, sometimes it is normal not to block for 20 minutes. These 20 minutes, together with the confirmation waiting time and other processing time of various trading websites, often result in extremely slow recharge and withdrawal speed. It is common to wait for an hour. Waiting for a bitcoin transaction is really a boring thing, which limits its application in reality. Even for this reason, a third party, similar to Alipay's third party centralization letter, is needed to solve.
the two-and-a-half block time of LTC greatly alleviates this problem. An LTC transaction will be completed in a short time without any anxious waiting. It can be said that LTC solves the problem of BTC
2, centralization
although BTC claims to be a decentralized currency, it is relative to legal currency. In practice, e to historical problems and ASIC mining machine problems, BTC's centralization problem is very serious, which can be discussed from two aspects
the first is the centralization of computing power. Although ASIC mining machine is inevitable in history, BTC is rising rapidly, so the centralization of computing power is very serious. It can be seen from this picture that the first and second mines are ready to start 51%. Although it is said that 51% will destroy the whole network, which is not good for the mining pool, bitcoin is a place outside the law after all. Everything is guaranteed by mathematical formulas and algorithms, and credit is established voluntarily. In the face of huge profit temptation, it is inevitable that nothing will happen, or the confidence of the holders will be affected. This is not good for bitcoin
some people say that LTC will develop special mining machines sooner or later, so as to enter the era of centralization. I think there is a degree of problem. After all, it is a fact that bitcoin mines are seriously concentrated, and as long as the concentration of LTC is lower than BTC, the risk can be smaller
the second is the centralization of holding money. I don't have statistics of LTC holding currency here, but I have statistics of BTC holding currency. This centralization of holding money is appalling. This means that a very small number of people control the vast majority of the wealth of the entire network. Of course, some addresses belong to the exchange, but this is absolutely very serious differentiation. Here's the data: http://btc.ondn.net/search
and the centralization of computing power aggravates this situation: half of bitcoin has been g out and concentrated in the hands of a few people, and then the rest that has not been g out will also be g out by a few people (because of the concentration of computing power). The new people have no choice but to pay for it
although some people refute me that since BTC is valuable, it should be exchanged with legal currency. The problem is that when the existing BTC has been monopolized, the future BTC will also be monopolized, and the price is not set by the buyer. It's like everyone says that China's real estate is unfair. If the existing houses are controlled by a few "real estate uncle" people, The land development in the future is also tightly controlled by the Bureau of land and resources. Isn't it true that the common people have to pay for it, and how much they will pay for it is up to them
- the original attitude towards real estate changed when it came to BTC. Of course, the reason is that the bottom of the BTC holder determines the head. As if you bought a few suites, you will say that the real estate market is fair
by contrast, LTC has only g up a quarter of the total, and the computing power is relatively average. Any ordinary people can buy a graphics card to dig their own mines. At least the new LTC can be obtained at a relatively balanced price. From this point of view, if the overall value of e-money needs to be increased by 10 billion or even 100 billion US dollars in the future, then adding all of them to BTC will only lead to a few people becoming millionaires of 100 billion US dollars, which is obviously not the original intention of developing e-money< There is a serious problem with Nakamoto's BTC, which is that Nakamoto has more than 2 million BTCs. Now we are willing to believe that Nakamoto is a good man and a God, but how can we trust an indivial when we believe in mathematics and physics? On the premise of minimum trust, Nakamoto is also a mortal. If the market value of BTC is large enough, Nakamoto's goods will become a time bomb. Even if he doesn't drop the price, he becomes the God of the world and has the most wealth. Not to mention that some BTCs confiscated by the FBI will be auctioned sooner or later. This good thing that has contributed to the American people will be left to the people of the world
LTC does not have this problem. The history is very clean. We dig together and everything is open. When digging LTC, many players already have BTC experience, so the mining is relatively balanced at the beginning, and there is no private situation such as the founding team stealing. This has laid a good foundation for LTC.
4. Whether the gold silver ratio is applicable to BTC and LTC is a funny question, which just shows the ignorance of public speculators. Bitkin, Wright silver, said that this statement of the media is a manifestation of extreme ignorance
first of all, is the value of e-money related to the circulation? If the circulation of LTC is a quarter of that of BTC, is the value of LTC a quarter of that of BTC? If I issue a kind of NCC with brain damage now, with only one circulation, should the price be 9999999
it's just as ridiculous to anchor the issue volume as to compare the circulation of stocks. Money can only be valued by the total market value. It's meaningless to talk about circulation. As for the gold and silver ratio, it's a big laugh. The ratio of gold and silver is determined by the instrial value and output of gold and silver. Electronic money has no value other than monetary property, and there is no such thing as output and reserves. The output and reserves of money are only monetary units. If you don't understand this, you can go back to the furnace
moreover, BTC and LTC have direct exchange markets, and their proportion is the result of market game, which is the short-term optimal solution in itself. There is nothing to say. What the market says is what it says, which has nothing to do with the current market, let alone gold and silver
5. About Shanzhai coin
some people say that LTC is also a kind of "counterfeit" currency, which has no value. Some people think that with so many counterfeit coins, you can fry any one that is not. I think both views are wrong
first of all, BTC is an open-source e-coin, and the word "Shanzhai" itself contains a strong central idea in the minds of the Chinese people, hoping that an Immortal Emperor or Nakamoto congda God has made a kind of immortal coin, and the others are all from "Shanzhai". In the open source world, everyone has the right to make money. Any money is "counterfeit" money. Bitcoin was worthless before, and its value was given after the market recognized it. As long as another currency can also be recognized and accepted by the market, it is reasonable to give it a market value, and the amount of market value given is also determined by the market, which may not exceed bitcoin
assuming that the long-term market is effective, excluding speculation, whether a currency can be given value by the market mainly depends on several factors (I personally think)
bitcoin is rising wildly, and e-money has set off a wave of speculation. Light currency (LTC) soared more than ten times, reaching a high price of 300 yuan. At the same time, a large number of counterfeit coins appeared, and the increase was amazing. It's not unusual to see them rise several times a day. E-money market has shown a strong speculative, investment risk has emerged. But is bitcoin the only winner? Is there any other e-coin that can "" the miracle of bitcoin, or even surpass it
assuming the success of e-money in the future, some people say that we only need one e-money. If the number of bitcoin is limited, it's OK to use mbtc or smaller units to trade when the price is very high. Other electronic coins are repetitive and meaningless
let's see how bitcoin has changed from "meaningless behavior" to a successful case, and what experience can be summed up
firstly, based on the combination of private key and public key of electronic cryptocurrency, bitcoin creatively proposed the block chain mechanism, as well as the binding of mining (protecting the whole network) and currency issuance rewards. And the implementation of a constant total to create deflation expectations, difficulty automatic adjustment to ensure fairness, as well as competitive mining and competitive block branches, to maximize the protection of the interests of the holders and miners, to achieve a win-win situation
this mechanism mobilizes the enthusiasm of miners and forms a virtuous circle. BTC rises, calculating power rises, calculating power rises, BTC is more stable and has higher value, so as to promote the price to continue to rise. Until now, bitcoin has formed an indestructible block chain system, which is the most valuable part of the bitcoin system, ensuring the maximum security of bitcoin holders, as well as the decentralized network structure, ensuring the openness and fairness of the bitcoin world. Social capital has invested a lot in bitcoin, forming a whole instrial chain. This is the value created by bitcoin from scratch. Although there are speculative factors, to a certain extent, the market value of bitcoin reflects this value
BTC market value: http://blockchain.info/charts/market-cap
BTC calculation force: http://blockchain.info/charts/hash-rate
but does this mean that bitcoin must be the most successful, and it will forever occupy the market share of the whole e-money in the future without further improvement
next, I'll make a comparison with LTC. Instead of recommending buying LTC, I'll talk about whether LTC can solve some problems of BTC and whether it will cause some new troubles< First of all, BTC has the following problems:
1, long confirmation time
I casually selected the current mining records and found that the block confirmation time was too long. First of all, the BTC default 10 minutes out of the block, has been a relatively long time. For some deals, it's a time of impatience. And because the difficulty is already very high, the block time is further uneven, sometimes it is normal not to block for 20 minutes. These 20 minutes, together with the confirmation waiting time and other processing time of various trading websites, often result in extremely slow recharge and withdrawal speed. It is common to wait for an hour. Waiting for a bitcoin transaction is really a boring thing, which limits its application in reality. Even for this reason, a third party, similar to Alipay's third party centralization letter, is needed to solve.
the two-and-a-half block time of LTC greatly alleviates this problem. An LTC transaction will be completed in a short time without any anxious waiting. It can be said that LTC solves the problem of BTC
2, centralization
although BTC claims to be a decentralized currency, it is relative to legal currency. In practice, e to historical problems and ASIC mining machine problems, BTC's centralization problem is very serious, which can be discussed from two aspects
the first is the centralization of computing power. Although ASIC mining machine is inevitable in history, BTC is rising rapidly, so the centralization of computing power is very serious. It can be seen from this picture that the first and second mines are ready to start 51%. Although it is said that 51% will destroy the whole network, which is not good for the mining pool, bitcoin is a place outside the law after all. Everything is guaranteed by mathematical formulas and algorithms, and credit is established voluntarily. In the face of huge profit temptation, it is inevitable that nothing will happen, or the confidence of the holders will be affected. This is not good for bitcoin
some people say that LTC will develop special mining machines sooner or later, so as to enter the era of centralization. I think there is a degree of problem. After all, it is a fact that bitcoin mines are seriously concentrated, and as long as the concentration of LTC is lower than BTC, the risk can be smaller
the second is the centralization of holding money. I don't have statistics of LTC holding currency here, but I have statistics of BTC holding currency. This centralization of holding money is appalling. This means that a very small number of people control the vast majority of the wealth of the entire network. Of course, some addresses belong to the exchange, but this is absolutely very serious differentiation. Here's the data: http://btc.ondn.net/search
and the centralization of computing power aggravates this situation: half of bitcoin has been g out and concentrated in the hands of a few people, and then the rest that has not been g out will also be g out by a few people (because of the concentration of computing power). The new people have no choice but to pay for it
although some people refute me that since BTC is valuable, it should be exchanged with legal currency. The problem is that when the existing BTC has been monopolized, the future BTC will also be monopolized, and the price is not set by the buyer. It's like everyone says that China's real estate is unfair. If the existing houses are controlled by a few "real estate uncle" people, The land development in the future is also tightly controlled by the Bureau of land and resources. Isn't it true that the common people have to pay for it, and how much they will pay for it is up to them
- the original attitude towards real estate changed when it came to BTC. Of course, the reason is that the bottom of the BTC holder determines the head. As if you bought a few suites, you will say that the real estate market is fair
by contrast, LTC has only g up a quarter of the total, and the computing power is relatively average. Any ordinary people can buy a graphics card to dig their own mines. At least the new LTC can be obtained at a relatively balanced price. From this point of view, if the overall value of e-money needs to be increased by 10 billion or even 100 billion US dollars in the future, then adding all of them to BTC will only lead to a few people becoming millionaires of 100 billion US dollars, which is obviously not the original intention of developing e-money< There is a serious problem with Nakamoto's BTC, which is that Nakamoto has more than 2 million BTCs. Now we are willing to believe that Nakamoto is a good man and a God, but how can we trust an indivial when we believe in mathematics and physics? On the premise of minimum trust, Nakamoto is also a mortal. If the market value of BTC is large enough, Nakamoto's goods will become a time bomb. Even if he doesn't drop the price, he becomes the God of the world and has the most wealth. Not to mention that some BTCs confiscated by the FBI will be auctioned sooner or later. This good thing that has contributed to the American people will be left to the people of the world
LTC does not have this problem. The history is very clean. We dig together and everything is open. When digging LTC, many players already have BTC experience, so the mining is relatively balanced at the beginning, and there is no private situation such as the founding team stealing. This has laid a good foundation for LTC.
4. Whether the gold silver ratio is applicable to BTC and LTC is a funny question, which just shows the ignorance of public speculators. Bitkin, Wright silver, said that this statement of the media is a manifestation of extreme ignorance
first of all, is the value of e-money related to the circulation? If the circulation of LTC is a quarter of that of BTC, is the value of LTC a quarter of that of BTC? If I issue a kind of NCC with brain damage now, with only one circulation, should the price be 9999999
it's just as ridiculous to anchor the issue volume as to compare the circulation of stocks. Money can only be valued by the total market value. It's meaningless to talk about circulation. As for the gold and silver ratio, it's a big laugh. The ratio of gold and silver is determined by the instrial value and output of gold and silver. Electronic money has no value other than monetary property, and there is no such thing as output and reserves. The output and reserves of money are only monetary units. If you don't understand this, you can go back to the furnace
moreover, BTC and LTC have direct exchange markets, and their proportion is the result of market game, which is the short-term optimal solution in itself. There is nothing to say. What the market says is what it says, which has nothing to do with the current market, let alone gold and silver
5. About Shanzhai coin
some people say that LTC is also a kind of "counterfeit" currency, which has no value. Some people think that with so many counterfeit coins, you can fry any one that is not. I think both views are wrong
first of all, BTC is an open-source e-coin, and the word "Shanzhai" itself contains a strong central idea in the minds of the Chinese people, hoping that an Immortal Emperor or Nakamoto congda God has made a kind of immortal coin, and the others are all from "Shanzhai". In the open source world, everyone has the right to make money. Any money is "counterfeit" money. Bitcoin was worthless before, and its value was given after the market recognized it. As long as another currency can also be recognized and accepted by the market, it is reasonable to give it a market value, and the amount of market value given is also determined by the market, which may not exceed bitcoin
assuming that the long-term market is effective, excluding speculation, whether a currency can be given value by the market mainly depends on several factors (I personally think)
4. At present, there is no formal miner for Leyte coin. Only the prototype is in the testing stage. If you want to dig Wright's coin, you have to be honest and practical
just take a look at this detailed tutorial: http://wenku..com/view/f7f51dd3b8f67c1cfad6b85c.html
just take a look at this detailed tutorial: http://wenku..com/view/f7f51dd3b8f67c1cfad6b85c.html
5. The mining principle of lightcoin is the same as that of bitcoin, but the algorithm is different. In short, it is to use the computing power of your lightcoin mining equipment to solve mathematical problems, confirm lightcoin network transactions, and ensure the security of the entire lightcoin network system. As a reward, miners can get unequal lightcoin rewards. The total number of lightcoin is four times that of bitcoin
at present, lightcoin mining has entered the ASIC era, and the myth that ASIC was not suitable for lightcoin mining has been broken
if you want to mine the Leyte coin, it is recommended that you buy ASIC Leyte coin miner, and you'd better join a mine pool for mining. The more famous lightcoin machines in the market include A2, silverfish, KNC and so on. At present, Avalon, a famous supplier of bitcoin machines, also plans to research and develop lightcoin ASIC chips. Avalon's lightcoin chip is a 28nm process technology, which is in a leading position in the instry.
at present, lightcoin mining has entered the ASIC era, and the myth that ASIC was not suitable for lightcoin mining has been broken
if you want to mine the Leyte coin, it is recommended that you buy ASIC Leyte coin miner, and you'd better join a mine pool for mining. The more famous lightcoin machines in the market include A2, silverfish, KNC and so on. At present, Avalon, a famous supplier of bitcoin machines, also plans to research and develop lightcoin ASIC chips. Avalon's lightcoin chip is a 28nm process technology, which is in a leading position in the instry.
6. Litecoin is a kind of network currency based on "peer-to-peer" technology, which can help users pay to anyone in the world immediately
at present, lightcoin is the second virtual currency after bitcoin in global circulation market value. The legends of bitcoin, Wright silver, infinite copper and pennies aluminum (Internet) are popular in the circle
the popular digital currencies in 2013 include bitcoin, Leyte coin, zeta coin, pennies (Internet), invisible gold bar, red coin, pole coin, barbecue coin and prime currency. At present, hundreds of digital currencies are issued all over the world
litecoin is inspired by bitcoin (BTC) and has the same implementation principle in technology. The creation and transfer of litecoin is based on an open source encryption protocol and is not managed by any central authority. Litecoin aims to improve bitcoin. Compared with bitcoin, litecoin has three significant differences. First, the liteoin network can process a block every 2.5 minutes (instead of 10 minutes), so it can provide faster transaction confirmation. Second, the output of litecoin network is expected to be 84 million litecoin, which is four times the amount of currency issued by bitcoin network. Thirdly, in its workload proof algorithm, litecoin uses the scrypt encryption algorithm first proposed by Colin Percival, which makes it easier to mine litecoin on ordinary computers than bitcoin. Each litecain is divided into 100000000 smaller units, defined by eight decimal places
lightcoin is generated by "miner's mining". Mining is done by hashing with computer graphics card. If the value of "mine explosion" is calculated, the system will reward 50 lightcoin at one time. At present, the computing power of lightcoin is growing rapidly, and miner can't dig mine through several computers. Therefore, it is necessary to join the mine pool, which collects all the computing power, It is estimated that the probability of calculating the "blasting" value is higher
at present, the well-known ore pools abroad include wemineltc, coinotron, etc
at present, lightcoin is the second virtual currency after bitcoin in global circulation market value. The legends of bitcoin, Wright silver, infinite copper and pennies aluminum (Internet) are popular in the circle
the popular digital currencies in 2013 include bitcoin, Leyte coin, zeta coin, pennies (Internet), invisible gold bar, red coin, pole coin, barbecue coin and prime currency. At present, hundreds of digital currencies are issued all over the world
litecoin is inspired by bitcoin (BTC) and has the same implementation principle in technology. The creation and transfer of litecoin is based on an open source encryption protocol and is not managed by any central authority. Litecoin aims to improve bitcoin. Compared with bitcoin, litecoin has three significant differences. First, the liteoin network can process a block every 2.5 minutes (instead of 10 minutes), so it can provide faster transaction confirmation. Second, the output of litecoin network is expected to be 84 million litecoin, which is four times the amount of currency issued by bitcoin network. Thirdly, in its workload proof algorithm, litecoin uses the scrypt encryption algorithm first proposed by Colin Percival, which makes it easier to mine litecoin on ordinary computers than bitcoin. Each litecain is divided into 100000000 smaller units, defined by eight decimal places
lightcoin is generated by "miner's mining". Mining is done by hashing with computer graphics card. If the value of "mine explosion" is calculated, the system will reward 50 lightcoin at one time. At present, the computing power of lightcoin is growing rapidly, and miner can't dig mine through several computers. Therefore, it is necessary to join the mine pool, which collects all the computing power, It is estimated that the probability of calculating the "blasting" value is higher
at present, the well-known ore pools abroad include wemineltc, coinotron, etc
7. Compared with bitcoin mining, lightcoin mining is relatively easy. Because the difficulty of mining is relatively low. But at present, lightcoin mining has graally entered the era of ASIC miner competition. The computing power is constantly rising, and the computing power of large mines is approaching 51%. If you want to carry out lightcoin mining, you must buy professional ASIC lightcoin miner. However, the price of lightcoin miner is generally too high, and there will be more ASIC lightcoin miner with high computing power in the future, Computing power is not constantly pushing up. This is the same as the era of bitcoin ASIC miner last year. Last year, Avalon miner was born, which completely subverted the bitcoin mining instry. With the help of roast cat, the computing power suddenly increased, and the graphics card mining completely went out of people's sight. Although there are many bitcoin ASIC mining machines, Avalon mining machine has always been unique and constantly launched its own new procts.
8. There are mining machines supporting their own algorithms, which can be plugged in and connected to the Internet.
9. In the future, the price of display card will only increase, but not decrease.
how to realize the circulation effect in excel? Although excel is a professional data processing software, but in the loop is very reluctantly, especially for beginners, for the realization of the loop is unable to start, so today I learned Xiaobian to teach you how to realize the loop in Excel<
operation method of loop in Excel
loop is realized by iterative calculation
1. In the process of using Excel, we may encounter a situation that cells sometimes refer to themselves, that is, entering a formula such as "= B2 + 1" in cell B2 is a circular reference behavior. In order to avoid the generation of dead loop, there is an iterative strategy
2. In fact, we can use this iteration function to achieve the desired effect. For example, we want to implement the sum accumulation operation from 1 to 10. It can be realized by the following methods. Click the office button & gt“ Excel Options button<
how to realize the loop of Excel function
3. In the open excel options window, switch to the formula tab, check the "enable iterative calculation" item, enter "101" in the "maximum number of iterations" input box, and finally click "OK" to complete the setting
how to realize the loop of Excel function
4. Enter the formula "= if (A2 & gt= 100, 0, A2 + 1) "and press enter
how to realize the loop of Excel function
5. Then enter the formula "= B2 * A2" in the "sum" cell "B2" and press enter to complete the input<
how to realize the loop of Excel function
6. Finally, you can see the output result "5050", that is, the cumulative sum from 1 to 100 is 5050.
how to realize the loop of Excel function
how to realize the loop operation by using array formula
1. The array formula strongly supports the loop. Here, we still take "1 to 100 cumulative sum" as an example, and enter the formula "= sum (row (1:100))" in any cell<
how to realize the loop of Excel function
2. Then press "Ctrl + Shift + enter" at the same time to see the result. Moreover, because it is an array formula, curly brackets are added on the outside of the formula<
how to realize the circulation of Excel function
realize the circulation calculation by VBA editing
1. Switch to the "development tools" tab, click the "Visual Basic" button to enter the VBA editing environment (or press the keyboard shortcut key combination "Alt + F11")< 2. Right click "Microsoft Excel object" and select "insert" - & gt; from the pop-up menu“ Mole item
how to realize the circulation effect in excel? Although excel is a professional data processing software, but in the loop is very reluctantly, especially for beginners, for the realization of the loop is unable to start, so today I learned Xiaobian to teach you how to realize the loop in Excel<
operation method of loop in Excel
loop is realized by iterative calculation
1. In the process of using Excel, we may encounter a situation that cells sometimes refer to themselves, that is, entering a formula such as "= B2 + 1" in cell B2 is a circular reference behavior. In order to avoid the generation of dead loop, there is an iterative strategy
2. In fact, we can use this iteration function to achieve the desired effect. For example, we want to implement the sum accumulation operation from 1 to 10. It can be realized by the following methods. Click the office button & gt“ Excel Options button<
how to realize the loop of Excel function
3. In the open excel options window, switch to the formula tab, check the "enable iterative calculation" item, enter "101" in the "maximum number of iterations" input box, and finally click "OK" to complete the setting
how to realize the loop of Excel function
4. Enter the formula "= if (A2 & gt= 100, 0, A2 + 1) "and press enter
how to realize the loop of Excel function
5. Then enter the formula "= B2 * A2" in the "sum" cell "B2" and press enter to complete the input<
how to realize the loop of Excel function
6. Finally, you can see the output result "5050", that is, the cumulative sum from 1 to 100 is 5050.
how to realize the loop of Excel function
how to realize the loop operation by using array formula
1. The array formula strongly supports the loop. Here, we still take "1 to 100 cumulative sum" as an example, and enter the formula "= sum (row (1:100))" in any cell<
how to realize the loop of Excel function
2. Then press "Ctrl + Shift + enter" at the same time to see the result. Moreover, because it is an array formula, curly brackets are added on the outside of the formula<
how to realize the circulation of Excel function
realize the circulation calculation by VBA editing
1. Switch to the "development tools" tab, click the "Visual Basic" button to enter the VBA editing environment (or press the keyboard shortcut key combination "Alt + F11")< 2. Right click "Microsoft Excel object" and select "insert" - & gt; from the pop-up menu“ Mole item
Hot content