I'm not sure I completely understand what you're trying to do.

So, you want to look at the individual amounts in cell A1, not the actual
value of A1, to see if any are 2000 or greater? So, 600+600+600+600 would
not be displayed, since there are no individual values greater than 2000,
even though the total value is 2400? Is this correct?

If so, what is the reason for keeping all values in the same cell rather
than seperate cells? This makes the formula much more difficult, especially
since you don't seem to have the same number of values being added together.

What I'd recommend is placing your values in seperate cells, lets say A1
through A5. Then your formula could be

=IF(MAX(A1:A5)=2000,"Amount of "&SUM(A1:A5),"")

If this won't work, please post back with more details.

HTH,
Elkar




"vertigo" wrote:


Hi All,

I have a very basic knowledge of excel so please forgive me if this is
actually ridiculously easy to do.

What i'm trying to do is this:

I have a basic addition formula in A1. What i am trying to do is have
another cell read A1 and if there is any amounts of 2000 or more in the
addition sum i want it to say "amount of 2000" or what ever the amount
is.

So if the sum was say: 100+200+300+400. It wouldn't do anything but if
the sum was 100+200+2564. It would say "Amount of 2564".

All i have been able to do so far is have this message come up if the
result of the actual sum is 2000 or over but i can't get it to just
read the individual amounts in the sum.The formula i have been using
is:

=IF((A1=2000),"Amount of " &A1,"")

I hope this makes sense, if anyone can help i would greatly appreciate
it.

Thanks.


--
vertigo
------------------------------------------------------------------------
vertigo's Profile: http://www.excelforum.com/member.php...o&userid=35504
View this thread: http://www.excelforum.com/showthread...hreadid=552743