having a set $ amount be deducted from any given total

C

Colin2u

is there a formula that will have an exact $ amount be deducted from any
given total.
 
C

cvolkert

Not sure if there is enough info here - obviously you could just add
-100 to deduct 100 from every total. If the 100 could change, you ca
use a linked cell or named range. If you just want to do this once yo
can type the value to be subtracted, copy it, and Paste Special / Valu
/ Subtract. Not sure if this covers what you need come back with som
more detail if it doesn't. Thanks, Cha
 
C

Colin2u

ok!
Each month there is a total (different each month ending). whatever that
total is, I will like to deduct a set $ mount (lets say $100.) from the that
month ending total and place it in a spicific cell.
I hope this extra info help.
thank you!
 
Top