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

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?

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

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


"duethckey" wrote:

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?

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

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?

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

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

"Elkar" wrote:

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


"duethckey" wrote:

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?

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

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?

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

Circular reference could be your problem.

duethckey wrote:

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?

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

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"duethckey" wrote in message
...
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?

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

On Thu, 18 Oct 2007 10:22:02 -0700, duethckey
wrote:

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?

=A1-B1
--ron