Jun 15 2022 02:50 PM
Hi all,
I have 2 arrays like below:
d | e | f | |
array1 | 47 | 53 | |
90 | 129 | 97 | |
162 | 204 | 210 |
a | b | c | |
array2 | - | 40,727 | - |
- | - | 55,608 | |
92,680 | - | - |
What i need to do a sumproduct of the 2 arrays where - when the value in array2 is greater than 50,500, the formula is array1value*array2value*(1-0.5)
so 1 product is : 47*40,727
but for product where value > 50,000, product is 97*55607*(1-0.5)
Is this possible? really hope this makes sense
Jun 15 2022 03:03 PM
Jun 15 2022 03:12 PM