178k views
3 votes
True or false : formulas or functions cannot be nested inside of each other in excel.

User Olle Lind
by
7.7k points

1 Answer

3 votes

False

Formulas and functions can be nested inside each other in Excel, known as "nesting" functions. Nesting uses one function's output as the input for another function, enabling it to perform multiple calculations simultaneously.

An example would be using the SUM function inside an IF function to calculate the sum of a range of cells only if a specific condition is true.

User Sayyor Y
by
7.2k points