Excel Formula Help

[suegibson]

I am after some expertise in Excel. I want a formula to go into the Positive column and another for the Negative column. I want to tell excel if the figure in cell A2 is positive copy it to here and another formula if the figure in cell A2 is negative copy it here. I can then add the list positive figures and the negative figures separately. I am not sure if this would be a, if formula or not.

Positive Negative
20 20
50 50
-30 -30
10 10
-25

Thanks

[network]

You can use “if” function in excel

If you input your data in cell A2 then in another column where you want to see positive amounts , for example, in cell B2 - type =IF(A2>0,A2,0)
in cell C2, where you would like to be negative amounts, type =IF(A2<0,A2,0)

Finding If function in excel
In order to find "if" function go to Insert - function and search for a function “if”

[johndevid4]

If you have windows operating system then that is great for all, so for that, I have some information you just download the whole Microsoft office and that is great for all. In it, you will get a word, excel, powerpoint.