To return value that provide data to a formula

[flaminang]

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 |
+-------------------------------------------------------------------+

 

[norika]

Flaminang
input the following in e3 and copy to e5
=IF(B3>0,D3/B3,D3/C3)

HTH
norika