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.
Video of the Day
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.
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.
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.
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.
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.