| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
What's the correct formula to do the following:
Sum ((If A2<0, then A2(-1)+(B2*B3), A20 then (B2*B3)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
