IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT
 

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.

IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT
 

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)




"Karine" wrote:

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.

IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT
 

Instead of <, use . Misread your formula.

"Karine" wrote:

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.