B
brose
Is it possible to protect a formula and still be able to edit the contents in
the cell without changeing the formula.--
Brose
the cell without changeing the formula.--
Brose
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bj
No But: you can have your calculations in one set of cells. In another set
of cells reference the original set. (=A1 etc) and have the second set be
your Display set.
You can then write over the second set as needed, and "refresh defaults" by
re referencing the original set.
Ha
of cells reference the original set. (=A1 etc) and have the second set be
your Display set.
You can then write over the second set as needed, and "refresh defaults" by
re referencing the original set.
Ha
B
brose
Thank you, i still fall into the same problem though because if the user
changes a cell it will overide the =A1 formula. or am I missing something?
I know theres a way to make this work so thanks for any and all help
changes a cell it will overide the =A1 formula. or am I missing something?
I know theres a way to make this work so thanks for any and all help
B
bj
I guess I am not sure what you want to do.
If you want the display to change but have the cell not change you could do
something like in column b
=if(C1<>"",C1, Calculation)
This would let someone effectively write over the display in Column B by
entering something in column C
If I am reading what you are saying correctly, you want to be able to Enter
something directly in a cell but have the cell still have the original
equation. I really do not think this is possible. But hopefully there is a
wizard out there would can prove me wrong.
If you want the display to change but have the cell not change you could do
something like in column b
=if(C1<>"",C1, Calculation)
This would let someone effectively write over the display in Column B by
entering something in column C
If I am reading what you are saying correctly, you want to be able to Enter
something directly in a cell but have the cell still have the original
equation. I really do not think this is possible. But hopefully there is a
wizard out there would can prove me wrong.
G
Gord Dibben
brose
Have I got this right?
You have a formula in a cell and you want to edit that cell without making any
changes.
You know there's a way for this to work.
Post back when you get it done so's the rest of us can learn, please.
Perhaps show us what the formula looks like and what you want to edit.
Gord Dibben Excel MVP
Have I got this right?
You have a formula in a cell and you want to edit that cell without making any
changes.
You know there's a way for this to work.
Post back when you get it done so's the rest of us can learn, please.
Perhaps show us what the formula looks like and what you want to edit.
Gord Dibben Excel MVP
B
brose
thanks for the help, i will keep trying. starting to think that 2 colums is
the way i need to go.
the way i need to go.
B
brose
You have the problem right, unfortunatly Im having a heck of a time finding
a solution. thanks, will keep you posted
a solution. thanks, will keep you posted