Formula
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.
|