Microsoft Excel 2016 - Creating and Copying Simple Formulas

This guide will show you how to create and use simple formulas in Excel.

Creating Formulas


In Excel, there are two simple rules to follow when creating formulas:

When creating a formula it can be done by simply typing the information into the cell. However, there are easier ways to create formulas. 

Copying Formulas


Often times a formula in one cell is needed in other cells. This often occurs within the same row or column. Excel makes it easy to copy them by changing the cells in the formula to the correct cell when the formula is copied in the following manner:

If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or