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" wrote:

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 .

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


On Wed, 23 Apr 2008 04:19:01 -0700, Randall
wrote:

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 .