if then statements?

S

Scott Grippo

I am trying to set up a worksheet such that:

Excel combines data from cell 'A' and cell 'B'.
If the sum is positive then put result in cell 'C'.
If sum is negative then put result in cell 'D'.

Thanks if you can help.
Scott
 
F

Frank Kabel

Hi Scott
in C1 put the following formula
=IF((A1+B1)>0,A1+B1,"")
in D1:
=IF((A1+B1)<0,A1+B1,"")
copy these formulars for all required rows. Some comments
- If the sum is '0' nothing will be inserted in C or B

Frank
 
Top