Exel 2003

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

 

[FSt1]

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

 

[Gord Dibben]

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(D3740)

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