Excel - Math Equation in Excel - Episode 1768

847 views · Published 7 August 2013 · 2:34 · Indexed 27 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

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