There are a couple of things to note while typing a formula in Excel. You should see the result is simply the value of A1 + B1. Go ahead and type random numbers from A1 to A10 and B1 to B10 for our data set. Easy enough right?īefore we write our new formula, let’s add some data in columns A and B to work with. A1 is the first cell on the spreadsheet at the top left. Every row has a number and every column has a letter. How do we reference a cell inside the Excel formula? Well, that’s pretty easy. You could just type =2+2 in Excel and that would work also. In Excel, when you use a function like SUM, it makes more sense to use arguments. With the SUM function, Excel is expecting at least two arguments, which would be references to cells on the spreadsheet. Here you can see the results of this simple addition of two literal numbers.Įven though there is nothing wrong with this formula, it really isn’t necessary. For example, if you need to add 2 and 2 together, the function would be SUM and the arguments would be the numbers 2 and 2. We normally write this as 2 + 2, but in Excel you would write it as =SUM(2+2).
0 Comments
Leave a Reply. |