if then statements?

  • Thread starter Thread starter Scott Grippo
  • Start date Start date
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
 
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
 
Back
Top