answersLogoWhite

0

Not as such. A formula can contain lots of parts and lots of functions, so in effect there are formulas within a formula, but the whole thing is considered as being a single formula. All formulas begin with the equals sign, and there is always only one equals sign to start it, no matter what the components are. Here are two separate functions and then together as two functions, but still one formula:

=MAX(A2:A10)

=MIN(A2:A10)

=MAX(A2:A10)+MIN(A2:A10)

Often when building complex formulas, people will start by doing formulas separately and then combining them into one single formula, but the end result is still a single formula.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the nested formula of MS Excel?

A nested formula is where one or more functions are placed inside another function to make a formula. For example you can write a formula where you put an IF function within an IF function and this would be a nested formula.


In excel if value is in one column automaticlly put formula in another column?

There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.


Is it possible to put a suitcase inside another suitcase?

Yes, it is possible to put a suitcase inside another suitcase as long as the size and shape of the suitcases allow for it. This can be a convenient way to save space when traveling or storing luggage.


Is there a formula in Excel that will allow a cell to subtract from itself the amount entered into another cell?

No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:=A2-B2


How do you get boxes to put your apps in for iPod touch?

You Click The App , And Put It To A Another App . Then It Would Appear To Be Inside A Box - Bracefacee Nanaa ' .


What do doll makers truly put inside a stuffed doll?

You can put pillow stuffing, cotton balls, or another soft, light material.


How do you find 11.50 percent of 125000 formula in Excel?

Put the 125000 into one cell, say cell A2. Put 11.5% into another cell, say cell B2. Then in another cell you could have this formula: =A2*B2 That is the proper way to do it, but you could do it lots of other ways.


What did they put inside a PlayStation?

what do you put inside a playstation


Is it possible to put a blown up balloon inside another blown up balloon?

Yes, it is possible to put a blown-up balloon inside another blown-up balloon. This is commonly known as a "balloon inside a balloon" or "balloon nesting." It creates a layered effect and can be a fun way to decorate or create unique balloon arrangements.


Is it possible to make a marquee go diagonally?

Yes, you have to put a marquee tag inside another with different directions.


Can you put formula in the microwave for heating"?

No, it is not safe to put formula in the microwave for heating.


How does a pencil works?

A pencil works for having carbon inside it. when you put a lead inside it. There is another type of pen pencil