|
Difference function and argument for two simple amounts
This is a request for help with a simple difference calculation for two
adjacent cells, as described below. The example below may well be more understandable than my attempt to explain what is needed. Function and argument needed for the positive or negative difference between the amount for a given days sales last year and the amount for a given days sales this year. Last years daily sales are the standard, so if this years daily sales are more than last years sales, the difference will be a positive amount, but if this years daily sales are less than last years, the difference will be a negative amount. Running sums will be shown for each column. Below is the proposed layout example. Each row is for one day in a given month. Amounts shown are for four days only. The SUM totals are at the bottom of each column. Last Year This Year Difference Gross Sales Gross Sales 1214.00 1113.00 -101.00 1065.00 1712.00 647.00 2301.00 2812.00 511.00 4216.00 3330.00 -886.00 SUMs for the month 8796.00 8967.00 171.00 All the function arguments my search has turned up are for more complex difference function arguments. I am at wits end. Your help will be deeply appreciated. |
Difference function and argument for two simple amounts
Maybe......
=(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 "lawrencae" wrote: This is a request for help with a simple difference calculation for two adjacent cells, as described below. The example below may well be more understandable than my attempt to explain what is needed. Function and argument needed for the positive or negative difference between the amount for a given days sales last year and the amount for a given days sales this year. Last years daily sales are the standard, so if this years daily sales are more than last years sales, the difference will be a positive amount, but if this years daily sales are less than last years, the difference will be a negative amount. Running sums will be shown for each column. Below is the proposed layout example. Each row is for one day in a given month. Amounts shown are for four days only. The SUM totals are at the bottom of each column. Last Year This Year Difference Gross Sales Gross Sales 1214.00 1113.00 -101.00 1065.00 1712.00 647.00 2301.00 2812.00 511.00 4216.00 3330.00 -886.00 SUMs for the month 8796.00 8967.00 171.00 All the function arguments my search has turned up are for more complex difference function arguments. I am at wits end. Your help will be deeply appreciated. |
Difference function and argument for two simple amounts
|
Difference function and argument for two simple amounts
CLR,
Thanks for trying. I really appreciate it, even though it was not the answer I used, which proved to be correct. That correct answer was: Assuming your headers are in row 1, clumns A:C and your data starts in row 2. In C2 put =B2-A2, then copy this down the column as far as you need. Below all the data in column A (eg in A100) put =SUM(A2:A99) and copy this to B100. Thanks again and regards, Lawrence "CLR" wrote: Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 "lawrencae" wrote: This is a request for help with a simple difference calculation for two adjacent cells, as described below. The example below may well be more understandable than my attempt to explain what is needed. Function and argument needed for the positive or negative difference between the amount for a given days sales last year and the amount for a given days sales this year. Last years daily sales are the standard, so if this years daily sales are more than last years sales, the difference will be a positive amount, but if this years daily sales are less than last years, the difference will be a negative amount. Running sums will be shown for each column. Below is the proposed layout example. Each row is for one day in a given month. Amounts shown are for four days only. The SUM totals are at the bottom of each column. Last Year This Year Difference Gross Sales Gross Sales 1214.00 1113.00 -101.00 1065.00 1712.00 647.00 2301.00 2812.00 511.00 4216.00 3330.00 -886.00 SUMs for the month 8796.00 8967.00 171.00 All the function arguments my search has turned up are for more complex difference function arguments. I am at wits end. Your help will be deeply appreciated. |
Difference function and argument for two simple amounts
Sandy,
Thanks for the follow through. You are to be applauded. That brands you as a real stand up person in my little book. =B2-A2 is the correct answser. CLR had mistakenly written, Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 Now to Scotland. I was married at Denny and Dunipace, Scotland a long time ago in another life (well, almost). I traveled by did not make it to Perth yet. I am in the Philippines as I write this. Best regards, Lawrence S. Miller "Sandy Mann" wrote: Why not just =B2-A2 or am I missing something? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "CLR" wrote in message ... Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 "lawrencae" wrote: This is a request for help with a simple difference calculation for two adjacent cells, as described below. The example below may well be more understandable than my attempt to explain what is needed. Function and argument needed for the positive or negative difference between the amount for a given day's sales last year and the amount for a given day's sales this year. Last year's daily sales are the standard, so if this year's daily sales are more than last year's sales, the difference will be a positive amount, but if this year's daily sales are less than last year's, the difference will be a negative amount. Running sums will be shown for each column. Below is the proposed layout example. Each row is for one day in a given month. Amounts shown are for four days only. The SUM totals are at the bottom of each column. Last Year This Year Difference Gross Sales Gross Sales 1214.00 1113.00 -101.00 1065.00 1712.00 647.00 2301.00 2812.00 511.00 4216.00 3330.00 -886.00 SUMs for the month 8796.00 8967.00 171.00 All the function arguments my search has turned up are for more complex difference function arguments. I am at wit's end. Your help will be deeply appreciated. |
Difference function and argument for two simple amounts
You're Very welcome. Chuck's answer does work as well.
-- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "lawrencae" wrote in message ... Sandy, Thanks for the follow through. You are to be applauded. That brands you as a real stand up person in my little book. =B2-A2 is the correct answser. CLR had mistakenly written, Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 Now to Scotland. I was married at Denny and Dunipace, Scotland a long time ago in another life (well, almost). I traveled by did not make it to Perth yet. I am in the Philippines as I write this. Best regards, Lawrence S. Miller "Sandy Mann" wrote: Why not just =B2-A2 or am I missing something? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "CLR" wrote in message ... Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 "lawrencae" wrote: This is a request for help with a simple difference calculation for two adjacent cells, as described below. The example below may well be more understandable than my attempt to explain what is needed. Function and argument needed for the positive or negative difference between the amount for a given day's sales last year and the amount for a given day's sales this year. Last year's daily sales are the standard, so if this year's daily sales are more than last year's sales, the difference will be a positive amount, but if this year's daily sales are less than last year's, the difference will be a negative amount. Running sums will be shown for each column. Below is the proposed layout example. Each row is for one day in a given month. Amounts shown are for four days only. The SUM totals are at the bottom of each column. Last Year This Year Difference Gross Sales Gross Sales 1214.00 1113.00 -101.00 1065.00 1712.00 647.00 2301.00 2812.00 511.00 4216.00 3330.00 -886.00 SUMs for the month 8796.00 8967.00 171.00 All the function arguments my search has turned up are for more complex difference function arguments. I am at wit's end. Your help will be deeply appreciated. |
Difference function and argument for two simple amounts
I know that feeling *very* well!
-- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "CLR" wrote in message ... Sandy, There are mornings where only one cup of coffee does it for me, and then there are mornings where it takes substantially more.........<g Vaya con Dios, Chuck, CABGx3 |
Difference function and argument for two simple amounts
Okie, dokie, give Chuck a pat on the ole back for me.
I believe you can tell that I am a newbie with Excel. I am involved in setting up a Daily Report (sales, expenses, and hoped for profit). It is quite a chore for me, but I hope to have it done shortly. Thanks to all your help. I hope you did not mind that I tried both your email addresses Sandy. Cherrio. Lawrence S. Miller "Sandy Mann" wrote: You're Very welcome. Chuck's answer does work as well. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "lawrencae" wrote in message ... Sandy, Thanks for the follow through. You are to be applauded. That brands you as a real stand up person in my little book. =B2-A2 is the correct answser. CLR had mistakenly written, Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 Now to Scotland. I was married at Denny and Dunipace, Scotland a long time ago in another life (well, almost). I traveled by did not make it to Perth yet. I am in the Philippines as I write this. Best regards, Lawrence S. Miller "Sandy Mann" wrote: Why not just =B2-A2 or am I missing something? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "CLR" wrote in message ... Maybe...... =(A2-B2)*-1 Vaya con Dios, Chuck, CABGx3 "lawrencae" wrote: This is a request for help with a simple difference calculation for two adjacent cells, as described below. The example below may well be more understandable than my attempt to explain what is needed. Function and argument needed for the positive or negative difference between the amount for a given day's sales last year and the amount for a given day's sales this year. Last year's daily sales are the standard, so if this year's daily sales are more than last year's sales, the difference will be a positive amount, but if this year's daily sales are less than last year's, the difference will be a negative amount. Running sums will be shown for each column. Below is the proposed layout example. Each row is for one day in a given month. Amounts shown are for four days only. The SUM totals are at the bottom of each column. Last Year This Year Difference Gross Sales Gross Sales 1214.00 1113.00 -101.00 1065.00 1712.00 647.00 2301.00 2812.00 511.00 4216.00 3330.00 -886.00 SUMs for the month 8796.00 8967.00 171.00 All the function arguments my search has turned up are for more complex difference function arguments. I am at wit's end. Your help will be deeply appreciated. |
| All times are GMT +1. The time now is 01:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com