Exel 2003
 

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 .

Exel 2003
 

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 .

Exel 2003
 

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 .