Thx. This is exactly what I wanted.

"JulieD" wrote:

Hi Earl

glad we're getting there, how about
=IF(COUNT(A1:C1)=3,IF(B1+C1A1,"Exceeded",IF(B1+C1 =A1,"*"&B1+C1&"*",B1+C1)),B1+C1)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Earl" wrote in message
...
JulieD:

The formula is exactly what I was looking for.

One follow up thought: Is there a way to amend the formula to 'flag' if
the
values entered exceed the maximum?

Thx.
Earl
"JulieD" wrote:

Hi Earl

try
=IF(AND(B1<"",C1<"",A1<"",B1+C1=A1),"*"&B1+C1&" *",B1+C1)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Earl" wrote in message
...
Ken,
Thx for the reply.
When I apply the formula it returns *0* whether column D has reached
it's
max. or not.

The closest I have gotten is; =IF(B1+C1=A1,"Maximum
Reached",SUM(B1+C1))
.

This is not what I want but maybe the only solution.


"Ken Hudson" wrote:

Hi Earl,
Try this in column D:

=IF(B1+C1=A1,"*" & B1+C1 & "*",B1+C1)

"Earl" wrote:

I have four columns of data. The first is the maximum no. allowed,
the
second
is the last period total, the third is the current period total and
the
fourth is the sum of two and three. The typical sum function works
fine
until
the fourth column equals the first, this is where I want to place an
asterisk
before and after the sum. This would indicate that the vlue has
reached
it's
max.

Is this possible?

Thanks.