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.