<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
| 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.
|
|
|
|
| > 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
| >
| >
| > |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?
| > |
|
|