Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sweepea Sweepea is offline
external usenet poster
 
Posts: 28
Default 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.