Can we apply two formulas in one cell in Excel
Manish Shori
Work in MS Excel with formula like Vlookup, Hlookup, Xlookup, Pivot table and many more| Simple typing work| Math and Science (Bio, Chemistry and Physics (with diagram)) equations| Any type of presentation
Yes, you can have two or more formulas in one cell in Excel by combining them using the ampersand (&) operator. This allows you to display the results of multiple formulas in a single cell. Here’s an example:
Suppose you want to calculate both the sum and the average of a range of cells A1:A10 and display the results in one cell. You can use the following formula:
="Sum of values is " & SUM(A1:A10) & ", Average of values is " & AVERAGE(A1:A10)
The result will be
If you want to display the results on separate lines within the same cell, you can use the CHAR(10) function to insert a line break:
="Sum of values is " & SUM(A1:A10) & CHAR(10) & "Average of values is " & AVERAGE(A1:A10)
The result will be
Note1: Make sure to enable Wrap Text in the cell formatting options to see the results on separate lines.
Note 2: In Excel, CHAR(10) is used to represent a line break.