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 / December 2005

Tip: Looking for answers? Try searching our database.

To return value that provide data to a formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
flaminang - 29 Dec 2005 09:22 GMT
Hi guys, i have a problem here. I have attached a sample of data. In the
example, i am trying to determine which useful life is being used to
calculate the monthly depreciation. The problem is that different
useful lives are used (ie different colums of useful life). I dont know
how to search within the formula and to return me the value of the
useful life that is being used.

+-------------------------------------------------------------------+
|Filename: sample.zip                                               |
|Download: http://www.excelforum.com/attachment.php?postid=4159     |
+-------------------------------------------------------------------+

Signature

flaminang

norika - 29 Dec 2005 09:54 GMT
Flaminang
input the following in e3 and copy to e5
=IF(B3>0,D3/B3,D3/C3)

HTH
norika

Signature

norika

 
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



©2008 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.