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.

Help with circular reference. Need workaround
 

Use no formulas

Say INPUT is cell A1. Enter your number in A1 (and any other cells you want)

In an un-used cell enter
..50025 and copy this cell. Then select the cells you want to update (A1 and
the rest) and paste/special with multiply checked.


Each cell will be updated as you require.

--
Gary's Student


"Corey" wrote:

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.

Help with circular reference. Need workaround
 

Gary,

Man, this solution was so simple, I feel dumb. I was definitly trying to
over-engineer the solution.

Thanks soo much.


"Gary''s Student" wrote:

Use no formulas

Say INPUT is cell A1. Enter your number in A1 (and any other cells you want)

In an un-used cell enter
.50025 and copy this cell. Then select the cells you want to update (A1 and
the rest) and paste/special with multiply checked.


Each cell will be updated as you require.

--
Gary's Student


"Corey" wrote:

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.

Help with circular reference. Need workaround
 

Don't feel dumb. I think it is a good idea to adjust values without
introducing lots of un-necessary formulae in your spreadsheets.

All you needed was the right technique.
--
Gary's Student


"Corey" wrote:

Gary,

Man, this solution was so simple, I feel dumb. I was definitly trying to
over-engineer the solution.

Thanks soo much.


"Gary''s Student" wrote:

Use no formulas

Say INPUT is cell A1. Enter your number in A1 (and any other cells you want)

In an un-used cell enter
.50025 and copy this cell. Then select the cells you want to update (A1 and
the rest) and paste/special with multiply checked.


Each cell will be updated as you require.

--
Gary's Student


"Corey" wrote:

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.