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


sike11 via OfficeKB.com wrote:
Hi All,

Please help!!

My problem is the following:

I have text in a column like this

A1
BTEC National Diploma
AS Economics
GCSE Maths

What I would like to happen in the next column is a formula like the
following:

IF A1 = "BTEC National" then A2 = 1
ELSE
IF A1 = "AS" then A2 = 2
ELSE
IF A1 = "GCSE" then A2 = 3

I am a little stumped as to how achieve this. Any ideas?

Thank you in advance!

Mary.

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

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