If Or formula

[Karen]

I want to write a formula so that if a number entered is negative it goes in 1 column and if it is positive it goes in a different column. Is there any way of doing this?
I appreciate any help.

Thank you in advance.

Karen

 

[JulieD]

Hi Karen

when using a formula it must go in the destination cells, i.e. if the value in A1 is positive you want to see the value in B1, otherwise you want to see the value in C1 then
in B1
type
=IF(A1>0,A1,"")
and in C1
type
=IF(A1<0,A1,"")

(BTW neither of these cater for A1 =0)

Hope this helps
Cheers
JulieD

I want to write a formula so that if a number entered is negative it goes in 1 column and if it is positive it goes in a different column. Is there any way of doing this?
I appreciate any help.

Thank you in advance.

Karen

 

[Andy B]

Hi

If the number is entered in A2, put this in B2
=IF(A2<0,A2,0)
to catch the negatives and put this in C2
=IF(A2>0,A2,0)
to catch the positives.

--
Andy.


I want to write a formula so that if a number entered is negative it goes in 1 column and if it is positive it goes in a different column. Is there any way of doing this?
I appreciate any help.

Thank you in advance.

Karen

 

[Karen]

Thank you so much!
Karen
Hi Karen

when using a formula it must go in the destination cells, i.e. if the value in A1 is positive you want to see the value in B1, otherwise you want to see the value in C1 then
in B1
type
=IF(A1>0,A1,"")
and in C1
type
=IF(A1<0,A1,"")

(BTW neither of these cater for A1 =0)

Hope this helps
Cheers
JulieD

I want to write a formula so that if a number entered is negative it goes in 1 column and if it is positive it goes in a different column. Is there any way of doing this?
I appreciate any help.

Thank you in advance.

Karen

 

[JulieD]

you're welcome
Thank you so much!
Karen
Hi Karen

when using a formula it must go in the destination cells, i.e. if the value in A1 is positive you want to see the value in B1, otherwise you want to see the value in C1 then
in B1
type
=IF(A1>0,A1,"")
and in C1
type
=IF(A1<0,A1,"")

(BTW neither of these cater for A1 =0)

Hope this helps
Cheers
JulieD

I want to write a formula so that if a number entered is negative it goes in 1 column and if it is positive it goes in a different column. Is there any way of doing this?
I appreciate any help.

Thank you in advance.

Karen