All numbers refer to either a gain or loss in quantity
Row 1 values are taken from one source
Row 2 values are taken from another source
I need a formula for row 3 to give me the total gain or loss represented in
each column.
Example
A B
1 (20.5) 17 Row 1
2 1.5 (2) Minus Row 2
3 (19) 15 Equal Row 3
=A1+A2 returns (19)
=B1+B2 returns 15
Gord Dibben MS Excel MVP
On Fri, 28 Mar 2008 10:37:00 -0700, wolfman <wol...@discussions.microsoft.com>
wrote:
Example
A B
1 (20.5) 17 20 (10) Row 1
2 1.5 (2) 10 (5) Minus Row 2
3 (19) 15 10 (5) Equal Row 3
In A3... = ABS(A1)-ABS(A2)
and copy across.
Rick
"wolfman" <wol...@discussions.microsoft.com> wrote in message
news:A3C444CF-9F27-495B...@microsoft.com...
If so, try this in A3:
=IF(A1*A2>0,A1-A2,A1+A2)
Copy across as required.
Hope this helps.
Pete
> > 3 (19) 15 Equal Row 3- Hide quoted text -
>
> - Show quoted text -