A
ASPENCO
I am attempting to write an array formula that performs a straight lin
depreciation calculation if multiple conditions are met and my curren
formula is returning a value of "false" even though there are "true
values in the range. For example, I would like to do the following:
Column A Column B
4 $10,000
10 $25,000
15 $12,000
20 $30,000
For all values in column A that exceed 12 I would like to compute
depreciation value using the sum of column b that meet this criteri
($42,000) as the cost value. But I only want to do this if for exampl
the value in cell A1>0. Thanks for your help
depreciation calculation if multiple conditions are met and my curren
formula is returning a value of "false" even though there are "true
values in the range. For example, I would like to do the following:
Column A Column B
4 $10,000
10 $25,000
15 $12,000
20 $30,000
For all values in column A that exceed 12 I would like to compute
depreciation value using the sum of column b that meet this criteri
($42,000) as the cost value. But I only want to do this if for exampl
the value in cell A1>0. Thanks for your help