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.