IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT

[Guest]

Hi,

I am trying to get a if statement that if the cells value is greater then
zero, it will add another cells value.

example :IF A2 >0, then the value in A6 , add the valueor A6 to the value in
A2.
Any help would be great.

 

[Guest]

If I understand you correctly, something like this should work.

Place value in A2, Place other value in A6
Say you want your formula in B2.

Then contents of B2 is =IF(A2<0,A2+A6,A2)

 

[Guest]

Instead of <, use >. Misread your formula.