In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.

Use this formula in cell C1 to divide the values of A2 and B2 together: In Cell C1, type in =A2/B2 Congratulations, you’ve now entered the values of two cells together.

How to Enter, Edit, or Delete Formulas in Excel ...

How do I fix the division formula in Excel? If the Division formula is not calculating correctly, you need to execute the solutions mentioned in this post to resolve the issue.

You must start with the "=" so that Excel knows you are entering a formula. It is important to know what type of data you are working with in order to select the correct forumla.