in the second column use an if condition like
=if(A1<1,"",if(A1<1000,"A",if(A1<2000,"B","C")))
you can have 7 such IFs

- Mangesh


^
How do I put this condition and where do I write these IFs?

--
Message posted from http://www.ExcelForum.com