Comment Varied Formula with airSlate SignNow

Put up formula pdf

hi everyone my name is Kevin today I want to show you how you can use a formulas in Microsoft Excel and is full disclosure before we jump into this I work at Microsoft as a full-time employee alright well let's jump into it Here I am in Microsoft Excel this is the latest version I have office 365 but these same formulas should work on any older versions of Excel as well whether you have 20 19 20 16 2013 20 2007 you name the version it'll probably work so here I am in Microsoft Excel and I have a list of formulas that I want to show you how you can use them in Excel if there's one that interests you more than others feel free to jump to that section of the video I have timestamps down below in the comments and you could just jump to the section that you find interesting so how do you do except there are formulas in Excel so I'm gonna we're going to start with the basics of add subtract multiply and divide so let's say that I have two numbers and cells I have 1 and 1 and I want to add these up how do I do that well the key to do in formulas in Excel is you always start with the equal sign so here I'm going to enter equal and what I could do is I could say well what is 1 plus 1 so I could just enter that in and you'll see that shows up in this formula bar up above so what I'm gonna do now is I'm just gonna hit enter and you'll see that it added those two values up so it says equals 1 plus 1 now what I can also do is instead of typing the numbers into that formula bar I could use numbers that are on my spreadsheet so what I'm gonna do is I'm going to go ahead and delete that and once again we're going to start with the equal sign and instead I'm going to say hey this value here that's in cell b1 let's take that and I want to add it to the value that's here in cell c1 and so I did the plus sign and then c1 and so here you see it says b1 plus c1 so it's taking those two cells and now I'm going to hit enter and so it added those two up and now I'm going to show a few example is a subtract multiply divide that you do them all the same way as addition so let's say I want to do 2 minus 1 what I'll do is I'll do equals we could do 2 minus 1 and hit enter and that'll tell us it's 1 but once again I want to use the cells so we're going to do cell b2 and we're going to subtract cell c2 then I'm gonna...