View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vertigo
 
Posts: n/a
Default Can anyone help please?


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