Subtracting two cells-one has existing formula????

D

duethckey

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?
 
E

Elkar

Since you didn't specify, let's assume your first cell is A1 and your second
cell (containing the formula) is A2. Use this formula:

=A1-A2

Note: the use of the SUM function in your existing formula is redundant.
Just use =L1-J1.

HTH,
Elkar
 
O

Otto Moehrbach

The fact that one is a formula result and the other a number is of no
consequence. Use something like:
=A1-B1
HTH Otto
 
D

duethckey

i tried this and it doesn't work properly....that is why I am confused. it
gives error of circular reference????
 
D

duethckey

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)
 
B

Bob I

Circular reference could be your problem.
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)



:
Click to expand...
 
R

RagDyer

See answer in your second post.

You should stick with one thread for a single subject, so that people don't
duplicate their efforts, or don't have the benefits of your added
explanations.
 
R

Ron Rosenfeld

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?
Click to expand...

=A1-B1
--ron
 
Top