Help with circular reference. Need workaround
I have a large set of sheets that need lots of data entered into multiple
colums. Each value that is entered into each cell needs to be modified by
the following formulat ((INPUT*0.375)*1.334), where INPUT is the cell the
data is entered into. Obviously the problem is a circular reference but the
other problem is the overwriting of the formula itself when the INPUT is
typed into the cell.
Is there a way to:
1. keep a formula from being overwritten when a value is typed into a cell
containing the formula?
2. (Tied to #1) Enter a value into a cell and have it modified or processed
by a funtion in that cell which then displays the result in that cell?
I've searched and read and nothing has yet provided me a solution.
|