Excell 98 Invoice Template : Change Cell Value or Function

[Robert Bulterman]

In the Invoice Template, all values of the cells in the right hand column
are added up at the bottom. The values in these cells are a result of a row
formula (Qty X Unit Price = Total). All I want to do, is learn how to change
the value a cell, while keeping the row formula (above), such that the Cell
Total in the right hand column is SUBTRACTED, instead of Added at the
Invoice Grand Total. Any Ideas? Your help is much appreciated. Robert.

 

[Harvey Waxman]

In the Invoice Template, all values of the cells in the right hand column
are added up at the bottom. The values in these cells are a result of a row
formula (Qty X Unit Price = Total). All I want to do, is learn how to change
the value a cell, while keeping the row formula (above), such that the Cell
Total in the right hand column is SUBTRACTED, instead of Added at the
Invoice Grand Total. Any Ideas? Your help is much appreciated. Robert.

Do you mean that one of the rows should be subtracted instead of added, like a
discount? Multiply it times -1. Qty X Unit Price = Total*-1

Does that help?