In addition to doing pretty complex calculations Excel can help you do simple arithmetic like adding subtracting multiplying or dividing any of your data. For example take a look at the IF function in cell D2 below. How to Use Spreadsheet Formulas in Excel.
After a while however this is no longer enough as we need to combine data from multiple sheets or even from other Workbooks.
Take this formula a step further and calculate the next month by adding EOMONTH start-date 1. FORMULAS IN EXCEL is an expression that operates on values in a range of cell addresses and operators. Start the formula with an sign select a cell enter an operator like or then select another cell. Array formulas can be used in two types.