How to Create Multiple Formulas for the Same Space in Excel

In Excel 2013, each cell only contains a single item, whether that item is a number or a formula. If you need to use two different formulas in the same cell, combine their functions and equations into a single item by using an ampersand or the IF function.

Combine Using an Ampersand

Excel's CONCATENATE function merges the results from several strings of text — including the output of formulas — in a single cell. The simplest way to use CONCATENATE is by typing an ampersand between each of your formulas.

Step

Start a new formula as usual with =, and then enter your first formula (or a number, text string or cell reference). Type an & and then enter your second formula. Use additional ampersands to string as many pieces together as necessary.

At this point, cell B3 displays the result 15.
At this point, cell B3 displays the result 15.
credit: Image courtesy of Microsoft
Add a space or other piece of text between each segment.
Add a space or other piece of text between each segment.
credit: Image courtesy of Microsoft

Step

Go back through the line of formulas and insert text strings in quotes, separated by additional ampersands, to visually separate the results of each formula. Press Enter to finish.

Combine Using IF

Use an IF function when you want Excel to perform one formula in certain conditions or another formula in different conditions. With IF, you get to write two separate formulas in one cell, but only one of the two operates at any time.

Step

Start an IF function with =IF( and a logical test. A logical test compares two pieces of data using equals, greater-than and less-than signs. A logical test can range from the simple, such as "=IF(A1=5" to testing the results of a formula, such as "=IF(SUM(A1:A3)>2". After the test, type a comma.

IF function checking for the sum of A.
credit: Image courtesy of Microsoft
This formula will sum B and display 30 because its test is true.
This formula will sum B and display 30 because its test is true.
credit: Image courtesy of Microsoft

Step

Type one formula to run if the logical test is true. Type a comma, and then type the other formula to run when the test is false. Close all open parentheses and press Enter to finish.