ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula help (https://www.excelbanter.com/excel-worksheet-functions/165242-formula-help.html)

Siper1

Formula help

What's the correct formula to do the following:

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

carlo

Formula help

On Nov 8, 3: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))

What exactly do you need the sum for?

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

hth carlo

joeu2004

Formula help

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)

All times are GMT +1. The time now is 02:10 PM.