HELP!!!

[TNTitans1974]

I am trying to get a sum to copy from another page, which I was able to do. Now I am trying to get it to move to another cell if its negitive or stay in the same cell if it is positive. Could someone help how to do this. I can't figure out the language to do an IFTHEN statement, and I don't even know if this is what I would use.

Thanks in advance

 

[barry houdini]

For the positive cell...

=If(SUM(sheet2!A1:A0)>0,SUM(sheet2!A1:A10),"")

and the negative.....

=If(SUM(sheet2!A1:A0)<0,SUM(sheet2!A1:A10),"")

if the sum is equal to zero then you'll get blanks in both cells

 

[Doug.T]

You would need 2 foumulas, 1 in each cell
positive cell would be =if(sum(myrange)>=0, sum(myrange),"")
The negative cell would be =if(sum(myrange)<0, sum(myrange),"")

 

[sgremmo]

If I understand correctly, i think that you must use If two time:

in cells where place positive =if(yourCell>0, yourCell,)
and in cells where place negative =if(yourCell>0, ,yourCell)

yourCell is riferiment of cell where you get sum!

Ciao

 

[TNTitans1974]

Thank you

Thank you so much... I greatly apprieciate the help. It worked..