Alert messages, running totals, connecting spreadsheets or cells
I need to be able to generate alert messages based on the result of a
calculation. I'll use the example of a checkbook and bank statement balance to explain what I'd like to do. I need to be able to calculate running totals, for example, as you would with your check book and that running total needs to be connected to another spreadsheet or another cell on the same spreadsheet (for example a bank statement running total). Also I need to connect the two spreadsheets or areas of the spreadsheet, so that if I enter an amount in the checkbook, it is reconciled with the bank statement balance. I need to calculate total outstanding checks, and final checkbook balance and final bank statement balance (& difference if they are out of balance) and then generate either Out of Balance or Good Balance alerts. I would appreciate any help. thank you. -- Cheryl |
Alert messages, running totals, connecting spreadsheets or cells
Chreryl
result in a1 = BoKu Bucks qualifier in b1 = if(a1="BoKu Bucks",1,"") Alert notification in c1 = if(b1=1,"Alert: You have BoKu Bucks. Share the Wealth! I'm a socialist, I can't help it.","") You could eliminate the c1 and just put it in b1, but I have found that I frequently go back and concatenate() various messages as I go along because you want to alert them for more than one thing. You want the alert near the qualifier so the see it immediately, but you may be calculating over a1:au10000. That makes it difficult to see any errors down there if your at the top. God Bless Frank Pytel "cheryl" wrote: I need to be able to generate alert messages based on the result of a calculation. I'll use the example of a checkbook and bank statement balance to explain what I'd like to do. I need to be able to calculate running totals, for example, as you would with your check book and that running total needs to be connected to another spreadsheet or another cell on the same spreadsheet (for example a bank statement running total). Also I need to connect the two spreadsheets or areas of the spreadsheet, so that if I enter an amount in the checkbook, it is reconciled with the bank statement balance. I need to calculate total outstanding checks, and final checkbook balance and final bank statement balance (& difference if they are out of balance) and then generate either Out of Balance or Good Balance alerts. I would appreciate any help. thank you. -- Cheryl |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com