|
Formula for subtracting
I have one cell with entered numbers (no formula in this cell). This is cell
J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2
"duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
=A1-A2
"Mike" wrote: A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2 "duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
Mike, I am so confused....
Here is what I have on the existing spreadsheet that I am trying to update: Column A is a manually entered number (17,000 for example) Column B was previously manually entered as a calculation on my calculator which was the number in Column A plus the number in Column B Column C is a formula column which is total of A plus B (=SUMA1:B1) What I want to do is place a formula in column B to calculate A plus B so I only manually enter Column A. Any help is greatly needed and appreciated! Thanks "Mike" wrote: =A1-A2 "Mike" wrote: A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2 "duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
<<<"What I want to do is place a formula in column B to calculate A plus
B" Have you re-read this? In B1 you want to enter a formula to add A1 to B1? ? ? Do you mean that if A1 contains 10, And you type 5 into B1, you want B1 to display 15? This creates a circular reference and can be very troublesome. Check out this link of JE McGimpsey: http://www.mcgimpsey.com/excel/accumulator.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "duethckey" wrote in message ... Mike, I am so confused.... Here is what I have on the existing spreadsheet that I am trying to update: Column A is a manually entered number (17,000 for example) Column B was previously manually entered as a calculation on my calculator which was the number in Column A plus the number in Column B Column C is a formula column which is total of A plus B (=SUMA1:B1) What I want to do is place a formula in column B to calculate A plus B so I only manually enter Column A. Any help is greatly needed and appreciated! Thanks "Mike" wrote: =A1-A2 "Mike" wrote: A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2 "duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
I understand but this is really what this spreadsheet needs to do. I figured
out away to make the circular reference work. Are you saying the danger is in the data entry error without the history? "RagDyer" wrote: <<<"What I want to do is place a formula in column B to calculate A plus B" Have you re-read this? In B1 you want to enter a formula to add A1 to B1? ? ? Do you mean that if A1 contains 10, And you type 5 into B1, you want B1 to display 15? This creates a circular reference and can be very troublesome. Check out this link of JE McGimpsey: http://www.mcgimpsey.com/excel/accumulator.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "duethckey" wrote in message ... Mike, I am so confused.... Here is what I have on the existing spreadsheet that I am trying to update: Column A is a manually entered number (17,000 for example) Column B was previously manually entered as a calculation on my calculator which was the number in Column A plus the number in Column B Column C is a formula column which is total of A plus B (=SUMA1:B1) What I want to do is place a formula in column B to calculate A plus B so I only manually enter Column A. Any help is greatly needed and appreciated! Thanks "Mike" wrote: =A1-A2 "Mike" wrote: A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2 "duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
Yes !
How well do you trust your users ... OR yourself? You've never made a mistake? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "duethckey" wrote in message ... I understand but this is really what this spreadsheet needs to do. I figured out away to make the circular reference work. Are you saying the danger is in the data entry error without the history? "RagDyer" wrote: <<<"What I want to do is place a formula in column B to calculate A plus B" Have you re-read this? In B1 you want to enter a formula to add A1 to B1? ? ? Do you mean that if A1 contains 10, And you type 5 into B1, you want B1 to display 15? This creates a circular reference and can be very troublesome. Check out this link of JE McGimpsey: http://www.mcgimpsey.com/excel/accumulator.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "duethckey" wrote in message ... Mike, I am so confused.... Here is what I have on the existing spreadsheet that I am trying to update: Column A is a manually entered number (17,000 for example) Column B was previously manually entered as a calculation on my calculator which was the number in Column A plus the number in Column B Column C is a formula column which is total of A plus B (=SUMA1:B1) What I want to do is place a formula in column B to calculate A plus B so I only manually enter Column A. Any help is greatly needed and appreciated! Thanks "Mike" wrote: =A1-A2 "Mike" wrote: A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2 "duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ????????? |
Formula for subtracting
You really should have the sum in column C.
Or, not sure if this helps in your case, but one method would be this. Copy column A. Select Column B. Go to Edit/Paste Special. Select Formulas, and Add. Click OK. Check the resulting formula in column B, perhaps that works for you? On Oct 18, 3:00 pm, duethckey wrote: I understand but this is really what this spreadsheet needs to do. I figured out away to make the circular reference work. Are you saying the danger is in the data entry error without the history? "RagDyer" wrote: <<<"What I want to do is place a formula in column B to calculate A plus B" Have you re-read this? In B1 you want to enter a formula to add A1 to B1? ? ? Do you mean that if A1 contains 10, And you type 5 into B1, you want B1 to display 15? This creates a circular reference and can be very troublesome. Check out this link of JE McGimpsey: http://www.mcgimpsey.com/excel/accumulator.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "duethckey" wrote in message ... Mike, I am so confused.... Here is what I have on the existing spreadsheet that I am trying to update: Column A is a manually entered number (17,000 for example) Column B was previously manually entered as a calculation on my calculator which was the number in Column A plus the number in Column B Column C is a formula column which is total of A plus B (=SUMA1:B1) What I want to do is place a formula in column B to calculate A plus B so I only manually enter Column A. Any help is greatly needed and appreciated! Thanks "Mike" wrote: =A1-A2 "Mike" wrote: A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2 "duethckey" wrote: I have one cell with entered numbers (no formula in this cell). This is cell J5 The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L I need to create a formual which allows me to add result of cell 7 minus cell J5 entry. ?????????- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 04:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com