Exel 2003

  • Thread starter Thread starter Randall
  • Start date Start date
R

Randall

Hi chaps i am back i need to do the followig put a + or - figure in Box D40
so that it will deduct or add the amount when i total D37 To D40 total to go
into Box 41.
Thank you .
 
hi
the field of mathmatic defines subtraction as "the addition of negative
numbers". if you put a negative number in D40, it will subtract by adding the
negative number to the total.

regards
FSt1
 
Randall

If you are going to be posting in these Excel news groups you should start to
lean the vernacular.

Excel sheets have "cells", not "boxes"

In D41 enter =SUM(D37:D40)

If you try to create a formula in D40 that references D40 you will get a
"circular reference" error message.

Most functions require that a helper cell has a formula referencing othe cells
as in the formula I provided above.


Gord Dibben MS Excel MVP
 
Back
Top