Help with formula, please.

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

 

[Don Guillett]

sounds kind of backwards??

 

[Guest]

The Total column is Total lbs. distributed, and the waste doesn't count as
distributed weight.

 

[Guest]

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.