Formula help

[Guest]

What's the correct formula to do the following:

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

 

[carlo]

What's the correct formula to do the following:

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

What exactly do you need the sum for?

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

hth carlo

 

[joeu2004]

What's the correct formula to do the following:

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

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

Alternatively:

=B2*B3 - min(0, A2)