How do you do a nested formula in Excel?

Answer 1

The short answer is that you can not, but there is a solution that will work for you. You are not able to automatically insert data into a cell from another cell; that would be a push of data, which Excel does not do. However, Excel can pull data from a cell.

1. Put your formula in a cell. Use A1 for this example.
2. Write another formula in the target cell to reference the value of A1. Use B1 for this example.
3. In B1, put the formula, =A1 to show the value of A1 in B1.

****this is not going to work for my prob dude.. check out discussion tab for more about my question, please. Please, please... please. :) need more help..

Answer 2

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)

Answer 3

You cannot have two formulas in one cell. It is possible to have a long formula which consists of many parts and which could have been done in several cells as individual formulas.

So for example you could have the following in A4:

=MAX(B1:B10)

Then in A5:

=A4*20

Or you could combine the two elements in one formula like this:

=MAX(B1:B10)*20

You need to take care with long complex formulas in a single cell, so it is often better to break them into a number of separate formulas. It also makes it easier to find errors. You could also start by having separate formulas and when you get them working, try to combine them into one.

Answer 4

A nested function is a function inside another one. Here is a MAX function nested inside a SUM function, where it is finding the highest number in the range A2 to A10 and adding it to 20.

=SUM(MAX(A2:A10),20)