On Nov 7, 10:23 pm, Siper1 wrote:
What's the correct formula to do the following:

Sum ((If A2<0, then A2(-1)+(B2*B3), A20 then (B2*B3))

=if(A2<0, -A2 + B2*B3, B2*B3)

Alternatively:

=B2*B3 - min(0, A2)