Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlo carlo is offline
external usenet poster
 
Posts: 367
Default 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