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 |
+-------------------------------------------------------------------+
--
flaminang
------------------------------------------------------------------------
flaminang's Profile:
http://www.excelforum.com/member.php...o&userid=29963
View this thread:
http://www.excelforum.com/showthread...hreadid=496597