Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
What is the formula for subtracting the sum total of two cells | Excel Discussion (Misc queries) | |||
Subtracting From 2 Cells | Excel Worksheet Functions | |||
Subtracting 2 Now() Cells | Excel Worksheet Functions | |||
The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions |