Excel Formula Help

Post Reply
Posts: 1
Joined: Mon Jul 19, 2010 2:23 pm

Excel Formula Help

Post by suegibson » Mon Jul 19, 2010 2:33 pm

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


Posts: 3
Joined: Fri Dec 18, 2009 10:59 am

Re: Excel Formula Help

Post by network » Tue Jul 20, 2010 8:56 pm

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”

Posts: 1
Joined: Wed Feb 06, 2019 8:21 pm

Re: Excel Formula Help

Post by johndevid4 » Wed Feb 06, 2019 8:27 pm

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.

Post Reply