Hi Shail,

Thanks! I also tried this and it did not work. Any suggestions?

shail wrote:
Hi Mary,

Try this one. Write this formula at cell A2

=IF(A1="BTEC National",1,IF(A1="AS",2,IF(A1="GCSE",3,"")))

Hope that helps.

Thankyou,
Shail

Hi All,

[quoted text clipped - 27 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1