Forum Discussion

Novice345's avatar
Novice345
Copper Contributor
Jun 15, 2022

Multiply 2 arrays with an if condition

Hi all,   I have 2 arrays like below:   d e f array1                   47                 53                   90               129                 97                 162   ...
excel
Novice345's avatar
Novice345
Copper Contributor
Jun 15, 2022
Hi, think i just solved it. =SUMPRODUCT(--(D38:F46>100000),(D38:F46)*(1-0.05),D25:F33). I just have to have a formula for <100K and >=100k and add them
Novice345's avatar
Novice345
Copper Contributor
Jun 15, 2022
Is there a way to do it in 1 formula? I tried this with solver and its giving me a linearity error

Resources