Could the fact that this is an existing spreadhseet and I am just now adding
the formula be the problem?

Exisiting spreadsheet:

A1 is where I entered number
B1 used to be manually calculated and is where I am trying to write the
formula where excel calculates C1-B1 which I have written =(C1-B1)
C1 is the existing formula written as =SUM (A1:B1)



"Otto Moehrbach" wrote:

The fact that one is a formula result and the other a number is of no
consequence. Use something like:
=A1-B1
HTH Otto
"duethckey" wrote in message
...
I have two cells that I need to subtract
First cell has entered number
Second cell number is result of existing formula which is =SUM (L1-J1)

How would this formula bet written?