Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |