That'll work.

Many thanks
--
AusTexRich


"Loris" wrote:

You can certainly accomplish it with a nested IF statement along these lines:
ASSUME THE TOTAL OF COLUMN WITH YOUR VALUES IS IN CELL C1,
=IF(C1=40,"MAXIMUM EXCEEDED",IF(C1<=-60,"MINIMUM EXCEEDED",""))
See if this works for you.

"AusTexRich" wrote:

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