The result of the EXP function should show on the selected cell, which is cell C3 in our illustration. After we’re done inputting the formula, all we need to do is press the “Enter” key.Then after choosing the value, we will be closing the formula by typing a close parenthesis ). For illustration purposes, we will be choosing 1 as the value. It could be a number, an equation, or a cell that has a numerical value in it. A green border should appear on cell C3, which indicates that we’re selecting it. As an illustration, we will be selecting cell C3. Select the cell where we want to input the result of the EXP function.Here’s an easy-to-follow guide on how to use the EXP function in Excel: Step-by-step Guide on How to use the EXP function Using the EXP function, we find out that the approximate population of the city after 5 years is 373,939. If we were to translate this formula into Excel terms, it should look like this:Īnd if we replace the variable with our data above, the formula should look like this: To do so, we will need to use the following formula:Ī = The approximate population after a set time Using e, we can approximate what the city’s population will be after five years. It is expected to grow annually at a rate of 2.5% for the next 5 years. We can also the EXP functions for complex calculations.įor example, let’s say that a city has a population of 330,000. So if you want to know the value of 2e, =EXP(2) is not the right formula.Įxample of Using e in complex calculations If we were to set n as 1, it should give us the numerical value of e. If we were to set n as 0, then it would result in 1 (which is always the result if you set the exponent of any number to 0). The EXP function also sets n as the exponent of e. It could be 0, 1, 13, or even an equation as long as it results in a number. The syntax for the EXP function is as follows: With it, we no longer have to memorize the numerical value of e as well as input it every time we need to use it. We can use e in excel by using the EXP function. Seeing how e is very useful, it’s no wonder why there is an Excel function for it. Oftentimes, these other variables are used as exponents of e. Most mathematical equations that use e also use a combination of a rate of growth or decay and a time period (e.g. It is especially useful in the areas of finance and statistics where there are a lot of factors that have a compounding or continuous growth. It is particularly useful in equations that involve compound or continuous growth.Īn example of this would be compounding interests.Īnother example would be the calculation of the ever growing human population.Īny logarithm that uses e as its base is considered a Natural logarithm. It is the result of the following equation (which is an infinite series): It’s an irrational number, which means that it can’t be written as a simple decimal or fraction. What is e (Euler’s Number)?Į or Euler’s number is a mathematical constant that has an approximate numerical value of 2.7182(…). We will also learn what e or Euler’s number is and its significance in mathematics and mathematical equations.īy the end of the article, we should have a better grasp of what Euler’s number is and how to use it in Excel. In this article, we will be learning how we can use e or Euler’s number in Microsoft Excel. That’s why it’s very helpful that we can use Excel to perform calculations that use Euler’s number. It’s especially useful in the areas of finance and statistics. It’s also an irrational number which is why we cannot show it as a simple fraction.Ī complicated number, but it is often used in many mathematical and scientific calculations. This is great as we can use Excel to perform calculations that involve such a very useful mathematical constant.Įuler’s number has an approximate numerical value of 2.71828(…). Let’s talk about another mathematical constant which is e or Euler’s number.Īnd just like π, Excel also recognizes Euler’s number. It should return us with the numerical value of pi which is 3.1416…. Just include the syntax PI() in your formula and you’re good to go. It even knows lots of the mathematical constants such as pi or π. You can use it to perform mathematical equations for you. With it, you can perform a plethora of functions. Microsoft Excel is such a wonderful piece of software.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |