0
Why doesn't the value of pi change when it is used in different formulas?
Wiki User
∙ 14y ago
Because that is the definition of a constant. Moreover, if it changed in different formulae then those formulae would either not work or they would be inconsistent.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
I would like to enter a formula into several cells of a spreadsheet and at a later date be able to enter a value amount into each of those cell formulas and have it calculate. Is this possible?
It is not totally clear as to what you want to do, so here are a few answer to different interpretations. If you have formulas and then type in numbers in their place, you would lose the formulas. You could edit the formulas and change a value within them. As much as possible, you should avoid having actual numbers in cells, especially when those values within the formulas are likely to change. You could also have a cell reference in the formulas and put values into those cells and then the formulas would pick them up with no need to change the formulas.It is not totally clear as to what you want to do, so here are a few answers to different interpretations. If you have formulas and then type in number in their place, you would lose the formulas. You could edit the formulas and change a value within them. As much as possible, you should avoid having actual numbers in cells, especially when those values within the formula are likely to change. You could also have a cell reference in the formulas and put values into those cells and then the formulas would pick them up with no need to change the formulas.
How did changing value affects the other part of the worksheet in Excel?
Worksheets have lots of formulas and they use values in cells. So if you change a value in a cell, any formula that uses that cell directly or indirectly can be affected by the change. How many other parts of the worksheet it will affect will depend on the particular worksheet, as each will have different formulas. Changing a value in a cell could affect one cell or many cells.
Does the value of pie change when you use it in different formulas?
No. I'm pretty sure you were talking about pi as in the number 3.14... if so, then no because since it is a number like 2 or 57 its value is always the same, no matter what formula.
Why should spreadsheet formulas be written in terms of cell references?
Because it makes a spreadsheet more flexible. It means you do not have to change formulas every time a value changes and you can use the same formula to add different values. It also makes formulas easy to copy. Those are just some reasons; there are many others.
When you set up a worksheet on Excel you should use cell references in formulas whenever possible rather than values?
Where possible you should always use cell references. It makes things a lot easier when you are changing or maintaining a spreadsheet. Even if you are using the exact same value in all of a set of formulas, you should put that value into one cell, and use an absolute reference in the formula to reference it. If formulas have cell references in them, then when figures change, you do not have to redo all the formulas. You just change the relevant figures and the formulas will all recalculate them.Values.
When a measurement is muliplied by a conversion fact the value of the measurement?
. . . does not change. It looks different, but its value is the same.
What do you do in order to Excel automatically update the value of a function?
Usually changing any value will cause all formulas to recalculate. So all functions will update and values may change. That is because automatic recalculation is normally on. If it is off, then you need to press the F9 key to update all formulas after making some change.
How do you connect two value in spreadsheet so that change in one leads to automatically change to other?
You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10You use formulas. Formulas can depend on the values in other cells. If you are summing a group of cells, then any change in those cells, will change the total. You can also make a cell exactly the same as another by and equals sign and a cell reference. So if you have a value in cell C10 and wanted cell B12 to show the same thing even when C10 has its value changed, then in B12 you would put:=C10
How can you have different values in algebraic expressions?
When the value of a variable in an algebraic expression changes, the value of the expression can change.
What is the highest number you can change the value to when using cheatengine 5.5 and hacking dragonfable for gold so the internet doesnt crash?
I think its 1 billion
'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?
'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '
When building formulas and functions it is BEST to refer to cell addresses within that function or formula?
Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.Yes. You should always use cell addresses in formulas rather than values. Values change, so if they are directly in a formula, you would have to keep changing the formula. It also makes the formulas more awkward to copy. By using cell references, then the values in those cells can be changed and the formula does not need to be. It also makes formulas easy to carry. Very occasionally a formula will include a value directly, but it should really only be done when you know that the value is never going to change. Even then, it is best to put the value in a separate cell and refer to it. It also makes the spreadsheet easier to follow as the value is visible on the sheet and should be suitably labelled.
