I have some calulations in my worksheet. They are done twice, if my
number is positive or negative.
I need to fill the cell next to my number with the calulation that
correspondes with the + or - of my number.


if A1 + if A1 -
A1 B1 C1 D1
-10 7 12

A2 B2 C2 D2
14 4 6
I need the 12 to appear in B1.

and the 4 to appear in B2.
Thanks

In B1 enter =IF(A1<0,D1,C1)

Copy down.


Gord Dibben MS Excel MVP

On Wed, 18 Nov 2009 12:03:24 -0800 (PST), Skip wrote:

I have some calulations in my worksheet. They are done twice, if my
number is positive or negative.
I need to fill the cell next to my number with the calulation that
correspondes with the + or - of my number.


if A1 + if A1 -
A1 B1 C1 D1
-10 7 12

A2 B2 C2 D2
14 4 6
I need the 12 to appear in B1.

and the 4 to appear in B2.
Thanks

the formula in B1 would be this
=if(a1<0,d1,c1)
Copy it down as far as needed.

This would lump 0 values in A with the positive. To have 0 with the
negatives use
=if(a1<=0,d1,c1)

--
If this helps, please remember to click yes.


"Skip" wrote:

I have some calulations in my worksheet. They are done twice, if my
number is positive or negative.
I need to fill the cell next to my number with the calulation that
correspondes with the + or - of my number.


if A1 + if A1 -
A1 B1 C1 D1
-10 7 12

A2 B2 C2 D2
14 4 6
I need the 12 to appear in B1.

and the 4 to appear in B2.
Thanks
.

Thanks for you help.
Skip