Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Cell Formula?
I have a sheet that contains various functions which is updated
regularly. The problem is, when updating, the formula never needs to be changed, only the number. I know it is possible to simply edit the number in the formula bar, but I was wondering if there was a way to "append" a formula to a certain cell, allowing the user to simply type in the number as they would a regular cell and not have to worry about altering the formula. Is this possible, or is it necessary to edit the number via the formula bar each time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Cell Formula?
Not sure what you mean, but instead of "=10*25" you can have a formula like "=A1*B1" and fill 10 in A1 and 25 in B1. You can
change A1 and B1 and get different results from the formula without changing the formula itself. -- Kind regards, Niek Otten Microsoft MVP - Excel "SenorSteve" wrote in message ups.com... |I have a sheet that contains various functions which is updated | regularly. The problem is, when updating, the formula never needs to | be changed, only the number. I know it is possible to simply edit the | number in the formula bar, but I was wondering if there was a way to | "append" a formula to a certain cell, allowing the user to simply type | in the number as they would a regular cell and not have to worry about | altering the formula. | | | Is this possible, or is it necessary to edit the number via the | formula bar each time? | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Cell Formula?
Hi,
Tip: You can use Names or labels You can do one of the following: On the Insert menu, point to Name and click Define and create a Named definiton for totals. -or- On the Insert menu, point to Name and click label definiton a label. In either cases you canjust change the value in the cell and the lable would take care. You need have to change or edit formula. For more information, refer to the following topics in the Microsoft Excel 2003 on-line help: About labels and names in formulas Challa Prabhu "SenorSteve" wrote: I have a sheet that contains various functions which is updated regularly. The problem is, when updating, the formula never needs to be changed, only the number. I know it is possible to simply edit the number in the formula bar, but I was wondering if there was a way to "append" a formula to a certain cell, allowing the user to simply type in the number as they would a regular cell and not have to worry about altering the formula. Is this possible, or is it necessary to edit the number via the formula bar each time? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Cell Formula?
Basically I have a several figures that are all divided by the same
number. However, the several figures aspect of the spreadsheet changes quite frequently, and all of the figures will always be divided by the same number. (eg, B4 {=5000 / A1}, B5 {=7000 / A1}, ...etc.) However, when one goes to change a number (lets say 5000 from the aforementioned example), the user must type ' = 5500 / A1'. The question was, is there was a way to streamline that to where certain designated cells were always divided by said cell. Hence, the user could just go through the spreadsheet and type '5500' and the appropriate change is made. I know I can decouple the implementation from the interface (sounds a lot like a visitor pattern ;-) ), however that would require an undesirable extra set of cells. On May 14, 3:02 am, "Niek Otten" wrote: Not sure what you mean, but instead of "=10*25" you can have a formula like "=A1*B1" and fill 10 in A1 and 25 in B1. You can change A1 and B1 and get different results from the formula without changing the formula itself. -- Kind regards, Niek Otten Microsoft MVP - Excel "SenorSteve" wrote in oglegroups.com... |I have a sheet that contains various functions which is updated | regularly. The problem is, when updating, the formula never needs to | be changed, only the number. I know it is possible to simply edit the | number in the formula bar, but I was wondering if there was a way to | "append" a formula to a certain cell, allowing the user to simply type | in the number as they would a regular cell and not have to worry about | altering the formula. | | | Is this possible, or is it necessary to edit the number via the | formula bar each time? | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Cell Formula?
<undesirable extra set of cells
You have 19 million+ cells available. Why bother? Just enter the 5000, 7000, etc in cells (you can use a separate sheet if you don't want to clutter the present one), define a meaningful name for them and change your formula to something like =InputAmount/A1 -- Kind regards, Niek Otten Microsoft MVP - Excel "SenorSteve" wrote in message ps.com... | Basically I have a several figures that are all divided by the same | number. However, the several figures aspect of the spreadsheet | changes quite frequently, and all of the figures will always be | divided by the same number. (eg, B4 {=5000 / A1}, B5 {=7000 / | A1}, ...etc.) However, when one goes to change a number (lets say | 5000 from the aforementioned example), the user must type ' = 5500 / | A1'. The question was, is there was a way to streamline that to | where certain designated cells were always divided by said cell. | Hence, the user could just go through the spreadsheet and type '5500' | and the appropriate change is made. | | I know I can decouple the implementation from the interface (sounds a | lot like a visitor pattern ;-) ), however that would require an | undesirable extra set of cells. | | | | | On May 14, 3:02 am, "Niek Otten" wrote: | Not sure what you mean, but instead of "=10*25" you can have a formula like "=A1*B1" and fill 10 in A1 and 25 in B1. You can | change A1 and B1 and get different results from the formula without changing the formula itself. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "SenorSteve" wrote in oglegroups.com... | | |I have a sheet that contains various functions which is updated | | regularly. The problem is, when updating, the formula never needs to | | be changed, only the number. I know it is possible to simply edit the | | number in the formula bar, but I was wondering if there was a way to | | "append" a formula to a certain cell, allowing the user to simply type | | in the number as they would a regular cell and not have to worry about | | altering the formula. | | | | | | Is this possible, or is it necessary to edit the number via the | | formula bar each time? | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Permanent formula? | Excel Worksheet Functions | |||
Making a column of numbers created from a formula permanent. | Excel Worksheet Functions | |||
permanent cell protection | Excel Discussion (Misc queries) | |||
How can I keep my cell borders permanent? | Excel Worksheet Functions | |||
How do change formula to permanent data? | Excel Discussion (Misc queries) |