G Guest Nov 8, 2007 #1 What's the correct formula to do the following: Sum ((If A2<0, then A2(-1)+(B2*B3), A2>0 then (B2*B3))
What's the correct formula to do the following: Sum ((If A2<0, then A2(-1)+(B2*B3), A2>0 then (B2*B3))
C carlo Nov 8, 2007 #2 What's the correct formula to do the following: Sum ((If A2<0, then A2(-1)+(B2*B3), A2>0 then (B2*B3)) Click to expand... What exactly do you need the sum for? =if(A2<0, abs(A2)+(B2*B3),B2*B3) hth carlo
What's the correct formula to do the following: Sum ((If A2<0, then A2(-1)+(B2*B3), A2>0 then (B2*B3)) Click to expand... What exactly do you need the sum for? =if(A2<0, abs(A2)+(B2*B3),B2*B3) hth carlo
J joeu2004 Nov 8, 2007 #3 What's the correct formula to do the following: Sum ((If A2<0, then A2(-1)+(B2*B3), A2>0 then (B2*B3)) Click to expand... =if(A2<0, -A2 + B2*B3, B2*B3) Alternatively: =B2*B3 - min(0, A2)
What's the correct formula to do the following: Sum ((If A2<0, then A2(-1)+(B2*B3), A2>0 then (B2*B3)) Click to expand... =if(A2<0, -A2 + B2*B3, B2*B3) Alternatively: =B2*B3 - min(0, A2)
