Frustratingly simple IF issue

[stevencampbellcarter]

Hi Everyone,

I have a really frustrating issue with what should be a simple formula. I want to say that
IF C12 is greater than or equal too 100 and less than 2500 = Name 1
IF C12 is greater than or equal too 2500 and less than 5000 = Name 2
If C12 is greater than or equal too 5000 equal Name 3
if anything else the equal Name 4

This is may formula which keeps on returning an error message whatever I do:
=IF(AND(C12>=1000,C12<2500),"Name1",IF(AND(C12>=2500,C12<5000),"Name2",IF(C12>=5000),"Name3","Name4"))

Can anyone please help?

Thanks

Steve

 

[JackDanIce]

Try:

=IF(C12>=5000,"Name3",IF(C12>=2500,"Name2",IF(C12>=100,"Name1","Name4")))

 

[bbott]

=IF(AND(C12>=1000,C12<2500),"Name1",IF(AND(C12>=2500,C12<5000),"Name2",IF(C12>=5000),"Name3","Name4")))

Remove the parentheses after 5000 and add a parentheses at the end. It should work.

 

[stevencampbellcarter]

It works like a dream, thanks!

 

[JackDanIce]

You're welcome