Excel - Math Equation in Excel - Episode 1768
847 views · Published 7 August 2013 · 2:34 · Indexed 27 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: How to Enter a Math Equation in Excel | MrExcel Podcast. Welcome to the MrExcel podcast. In this episode, we will be discussing how to do a math equation in Excel. As always, I'm your host Bill Jelen and I'm excited to dive into this topic. Recently, I came across a question on Twitter about entering a complex equation in Excel. The equation involved mathematical constants such as PI and e, as well as square roots and solving for a variable. It's been a while since I was really good at math, but I was determined to figure it out and share my findings with all of you. So, let's break down the equation. We start by using the equal sign, followed by 1 divided by the square root of 2 times PI. Remember to use parentheses around the PI to ensure it is calculated correctly. Next, we multiply this by the EXP of 1 raised to the power of -0.5 times the value in cell Z squared. This may seem complicated, but with a little practice, you'll get the hang of it. To test our equation, we need to provide some values for Z. I've created a range of values from -4 to 4 and plotted them on a scatter chart. As you can see, the values follow a smooth curve, which indicates that our equation is working correctly. Of course, if you are familiar with the equation, you can compare the chart to the expected values to ensure accuracy. Excel is great at handling formulas, but when it comes to complex equations like this, it can be a bit tricky. However, with the right knowledge and practice, you can easily incorporate mathematical equations into your Excel spreadsheets. Thank you for tuning in to this episode of the MrExcel podcast. Be sure to join us next time for more helpful tips and tricks. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Entering a Math Equation in Excel (00:10) Explanation of the Equation (00:21) Solving for R (01:00) Valid Range of Z Values (01:44) Creating a Scatter Chart (02:04) Analyzing the Chart (02:14) Excel's Formula Capabilities (02:24) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Creating a scatter chart in Excel Excel equation EXP function in Excel How to enter equation in Excel Mathematical calculations in Excel Solving for R in Excel Square root in Excel Tips for complex equations in Excel Using e constant in Excel Using formulas in Excel Using PI in Excel Valid range of values in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153589/ Excel is great at formulas, but how do you enter a math equation in Excel? Today's podcast looks at an equation with Square Root, Exponents, Pi, and e that need to be entered in Excel.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920