Question:

I like to input a number in a cell, but that cell will always have to
subtract the value from a designated cell. Is there a way to hard code the
formula?

Example:

A1 = XXX-$B$10

XXX is the input # and it always changing. So as long as I input XXX in that
cell, it will automatically subtract the value in B10.

Thank you for your help.

A easy way of doing it would be enter the number in Cell A1 and then have
Cell A2 =$A$1-$B$10

Any other way I would think that if you have a formula like A1=XXX-$B$10
when you type number "XXX" in that cell it will replace the formula, then
only other way is a redirect like above

"Sweepea" wrote:

Question:

I like to input a number in a cell, but that cell will always have to
subtract the value from a designated cell. Is there a way to hard code the
formula?

Example:

A1 = XXX-$B$10

XXX is the input # and it always changing. So as long as I input XXX in that
cell, it will automatically subtract the value in B10.

Thank you for your help.

Place the XXX in another cell then use the formula

=othercell-$B$10


Gord Dibben MS Excel MVP

On Mon, 8 Jan 2007 14:19:01 -0800, Sweepea
wrote:

Question:

I like to input a number in a cell, but that cell will always have to
subtract the value from a designated cell. Is there a way to hard code the
formula?

Example:

A1 = XXX-$B$10

XXX is the input # and it always changing. So as long as I input XXX in that
cell, it will automatically subtract the value in B10.

Thank you for your help.