That'll work. I was trying to get a Vba message box, but, this is one way.
Thanks
--
AusTexRich


"AusTexRich" wrote:

For clarity here's the model

D - G - H
1
2
3 A 5 5
4 B 10 15
5 C 5 20
6 D 21 41 Message displayed when value = 40
7 E -102 -61 Message displayed when value <= -60

Column D is an number that's entered
Column G looks up the value for the number in Col D
Column H keeps the running total



AusTexRich


"Bob Phillips" wrote:

A shot at what you might mean.

In B1,

=IF(SUM($B$1:B1)=40,"one message",IF(SUM($B$1:B1)<=-60,"another
message",""))

--
HTH

Bob Phillips

"AusTexRich" wrote in message
...
I've reviewed all of the questions and responses, but, didn't find
anything
similar to what I needed. My table has one column which adds values,
positive and negative, from another column or a running total, if you
will.
When a specific value, plus or minus, is reached I want a corresponding
message to display, i.e, when the value of the running total = 40 is one
message and when the running total <= -60 is the other. Can help?
--
AusTexRich