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.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast episodes 1768.
Do a Math Equation in Excel?
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today was watching Twitter and a question came across about, how to enter a equation in Excel and here's the equation that we're trying to do.
Boy! I used to be really good at math and it's been a while.
So, this is PI this is the mathematical constant e.
So, it really comes down to how do we do the PI, how do we do e, how do we do the square root, it looks likewe're trying to solve for R and we have an input cell of Z at least that's how I read.
Now, it's been a long time since I was really good at math.
So, I may have this completely wrong, but here's what we do.
So, we equal, do equal 1 divided by that handles the 1 divided by and then we want this square root, SQRTof 2 times PI, PI have to put open parenthesis and closed parenthesis afterward.
All right, so right now, I think we have this first part of the equation modeled right there and then I multiply that times ok, the mathematical constant e in Excel is the EXP of 1.
So, he is EXP of 1 and we're gonna raise that to I'm gonna put it all in parenthesis minus 1/2 so, minus 0.5 times Z is this value over here on A2 squared.
So, caret 2 is the way to square that and let's see there's our answer double-click to copy that down you have to provide some Z values here and part of the trick is figure out what the valid range of Z values are these numbers here are incredibly small so it looks like once we get past 4, it pretty much tails off to 0.
Let's, let's start this here at minus 4 and I have equations here that go basically from 4, minus 4 down to positive 4.
We'll take a look and see how this looks, we'll select our data the original Z values and the R values insert I'll do a Scatter chart the smooth one.
All right so, you'll have to you know if you know what this equations supposed to be doing, you can take a look at this chart and see if that is roughly the right values.
There you go.
Excel is great at doing formulas, but when you have an equation like this it's a little bit tricky figure out the square root, how to square something, how to raise something to another power, how to do the PI and the e constant.
So, there you have it.
Well hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Learn Excel from MrExcel podcast episodes 1768.
Do a Math Equation in Excel?
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today was watching Twitter and a question came across about, how to enter a equation in Excel and here's the equation that we're trying to do.
Boy! I used to be really good at math and it's been a while.
So, this is PI this is the mathematical constant e.
So, it really comes down to how do we do the PI, how do we do e, how do we do the square root, it looks likewe're trying to solve for R and we have an input cell of Z at least that's how I read.
Now, it's been a long time since I was really good at math.
So, I may have this completely wrong, but here's what we do.
So, we equal, do equal 1 divided by that handles the 1 divided by and then we want this square root, SQRTof 2 times PI, PI have to put open parenthesis and closed parenthesis afterward.
All right, so right now, I think we have this first part of the equation modeled right there and then I multiply that times ok, the mathematical constant e in Excel is the EXP of 1.
So, he is EXP of 1 and we're gonna raise that to I'm gonna put it all in parenthesis minus 1/2 so, minus 0.5 times Z is this value over here on A2 squared.
So, caret 2 is the way to square that and let's see there's our answer double-click to copy that down you have to provide some Z values here and part of the trick is figure out what the valid range of Z values are these numbers here are incredibly small so it looks like once we get past 4, it pretty much tails off to 0.
Let's, let's start this here at minus 4 and I have equations here that go basically from 4, minus 4 down to positive 4.
We'll take a look and see how this looks, we'll select our data the original Z values and the R values insert I'll do a Scatter chart the smooth one.
All right so, you'll have to you know if you know what this equations supposed to be doing, you can take a look at this chart and see if that is roughly the right values.
There you go.
Excel is great at doing formulas, but when you have an equation like this it's a little bit tricky figure out the square root, how to square something, how to raise something to another power, how to do the PI and the e constant.
So, there you have it.
Well hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
