Problem with Nested If statement

Hi,

I am having difficulties getting my nested If statement to work. I have been through it countless times and cannot for the life of me work out what is wrong.

What I want to do is pretty easy and I have done it before.

I have a whole lot of numbers in D2, I would like to categorise them as such; < 1000m, 1000- 2000 m, 2000-3000 m, 3000-4000 m, 4000- 5000m and > 5000 m.

I have used this formular but it keeps returning an error

=IF(D2<1000, "< 1000 m",IF(D2<2000, “1000-2000 m”,IF(D2<3000,”2000-3000 m”,IF(D2<4000,”3000-4000 m”,IF(D2<5000,”4000-5000 m”,IF(D2>=5000,”>5000 m”,”No”))))))

Any help would be greatly appreciated.

Thanks

Thanks very much for your help Norie.

Worked perfectly