Thread
:
Formula help
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
carlo
external usenet poster
Posts: 367
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
Reply With Quote
carlo
View Public Profile
Find all posts by carlo