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