Help with formula, please.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns--Total and Waste. Is there a way to format the Total
column with a formula that will allow me to enter a number into the Total
column and have it automatically subtract the number in the Waste column?

Thanks.
 
The Total column is Total lbs. distributed, and the waste doesn't count as
distributed weight.
 
You can't have a formula in a cell that depends on a value entered into that
same cell, as you can't enter the cell reference into its own cell, this
creates a circular reference. You will have to have a third column called
'Gross Weight' and simply have 'total'-'waste' and copy it down the length of
the column.
 
Back
Top