Select the cell where the answer will appear B4 for example. This short video tutorial shows how to enter a simple formula into your Excel sheet. MATHEMATICAL Functions in Excel.
Select a cell or type its address in the selected cell.
It starts counting from 1. Note the formula in the formula bar while the result we would expect is in cell B2. Select cell C3 and type an equal sign to begin the formula. Actually you and use shortcut keyboards to archive it easily in Excel.