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

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