I'm hoping someone may be able to help a newbie with an array problem I'm having.
Column A has various values. Column B has various values. Cell C1 has 100 as the value.
I need an array that multiples cell A1 * B1 to check to see if that value is > 0. Then multiples A2 * B2 to check if that is > 0 and so on through the end of the array. If any of those calculations yield a result that is > 0, then the array will take the result for each individual calculation and, if it is true, multiply the value in Column B by the value cell C1.
For example:
A1 = 10
A2 = 0
A3 = 15
B1 = 2
B2 = 3
B3 = 1
C1 = 100
The result of this should be 300 calculated as:
A1*B1>0 so B1 * C1 = 200
A2*B2=0 so do nothing
A3*B3>0 so B3 * C1 = 100
The result is 300. I need this result represented in a single cell. Can anyone help?
Thank you!
Troy
http://www.excelforum.com/excel-general/1120335-help-with-an-array-formula-to-compare-sum-then-multiply-result-by-a-constant.html
Bookmarks