Creating Complex Formulas

In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.

Creating complex formulas

Excel automatically follows a standard order of operations in a complex formula. If you want a certain portion of the formula to be calculated first, put it in parentheses.

Example of how to write a complex formula:

Sample Formula
Sample Formula

To show fewer decimal places, you can click the Decrease Decimal place command on the Home tab.

Excel will not always tell you if your formula contains an error, so it's up to you to check all of your formulas. To learn how to do this, you can read the Double-Check Your Formulas lesson from our Excel Formulas tutorial.