# How to Create Multiple Formulas for the Same Space in Excel

Techwalla may earn compensation through affiliate links in this story.
Image Credit: ijeab/iStock/GettyImages

The Microsoft Excel application allows you to enter data or a formula into each spreadsheet cell. When you enter a formula, you see the result displayed. Multiple formulas in one cell are not allowed, but built-in functions and nesting can be used to express a series of calculations and logical operations in a single formula. Using standard functions, you can build complex formulas that handle a variety of conditions.

## Creating an Excel Formula

An Excel formula is an equation that performs a calculation and comes up with a result. To differentiate between data and a formula in a cell, you begin a formula by typing an equal sign. Within the formula, you can include numbers and text strings; arithmetic operators for addition, subtraction, multiplication and division; and references to other cells. If you type "=5+2" into a cell and press the Enter key, the cell displays the result, which is the number 7. You can see the underlying formula in the Excel formula bar when you select the cell.

Video of the Day

## Combine Two Formulas in Excel With IF

Excel functions are predefined formulas for frequently used calculations. The IF function performs a logical test between two values, returning one value if the comparison is true and another if it's false. The syntax of the IF function is IF(test, value if true, value if false). For example, the formula =IF(C1>B1,C1-B1,0) compares the value in cell C1 to the value in cell B1. If the value in C1 is greater than B1, the result displayed in the cell is the difference between the values in C1 and B1. If the value in B1 is greater than C1, the displayed result is 0.