Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

Formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
agungf84 - 18 Jun 2006 07:57 GMT
Hi all,

I am new to this website and am wondering if anybody can help me. I
want to form a formula that if number 6000,4000,2000, or 0 appear, that
it will produce 20000.

Thanks!

Cheers,
Agung

Signature

agungf84

Reply to this Message
Mallycat - 18 Jun 2006 08:33 GMT
Not sure if this is the most elegant solution, but it will work

Assuming your data is in cell A1

=IF(OR(A1=2000,A1=4000,A1=6000,A1=0),2000,A1)

Matt

Signature

Mallycat

Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.