Trying to label data as Gainer or Decliner

[RyanEvert]

Using last years actuals for January and February and using this years January results +February forecast.

If the customer's year-over-year variance is positive they are label as a gainer, if their year-over-year variance is negative then they are labeled a decliner.

This is the formula I was trying to use and kept getting an error
=(if(sum(B2:C2>sum(D2,E2),"Decliner"))),(if((sum(B2:C2<sum(D2,E2),"Gainer"))),(if((sum(B2:C2=sum(D2,E2),"Gainer")))))

 

[DanteAmor]

Hi and welcome to MrExcel

This is the formula I was trying to use and kept getting an error
=(if(sum(B2:C2>sum(D2,E2),"Decliner"))),(if((sum(B2:C2<sum(D2,E2),"Gainer"))),(if((sum(B2:C2=sum(D2,E2),"Gainer")))))

Considering the example of your formula.

Try:

=IF(SUM(B2:C2)<=SUM(D2:E2),"Gainer","Decliner")

Example:

Dante Amor
	A	B	C	D	E	F
1
2		100	90	120	110	Gainer
Hoja1

Cell Formulas
Range	Formula
F2	F2	=IF(SUM(B2:C2)<=SUM(D2:E2),"Gainer","Decliner")

Or simply:

Dante Amor
	A	B	C	D	E	F
1
2		100	90	120	110	Gainer
Hoja1

Cell Formulas
Range	Formula
F2	F2	=IF(B2+C2<=D2+E2,"Gainer","Decliner")