Having trouble doing what I want with IF statements.

**poisontoast** · 10-21-2012, 02:03 AM

I'm trying to get cell A1 to display, HERO if cell B1 is <50, VETERAN if cell B1 =>50 but <100, EPIC if cell B1 is =>100.

I can get it to work with 2 values (if <, if >) but I cant figure out how to make it work with all the values.

Thanks for your time everyone!

**BeachRock** · 10-21-2012, 02:15 AM

Try this in cell A1.

=IF(B1<50,"HERO",IF(AND(B1>=50,B1<100),"VETERAN",IF(B1>=100,"EPIC"))

**:) Sixthsense :)** · 10-21-2012, 02:15 AM

Try this formula in A1 cell

Formula:

Please Login or Register  to view this content.

---

Sixthsense

**poisontoast** · 10-21-2012, 03:07 AM

@ BeachRock: It worked with an extra ")" at the end.

Thanks!

@

Sixthsense

: It worked with out changes. Thanks!

Thanks to both of you for your replies. I see why mine were not working now. I was not nesting correctly. Thank you both again for your time! + rep to both of you.