To return value that provide data to a formula
 

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

To return value that provide data to a formula
 

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

HTH
norika


--
norika
------------------------------------------------------------------------
norika's Profile: http://www.excelforum.com/member.php...fo&userid=4878
View this thread: http://www.excelforum.com/showthread...hreadid=496597