| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional IF statements
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
In A2,
=IF(A1="BTEC",1,IF(A1="AS",2,IF(A1="GCSE",3,""))) Regards, Alan. "sike11 via OfficeKB.com" <u21678@uwe wrote in message news:6c83fbaeba87d@uwe... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
Hi,
Thanks for the suggestion. However, it did not work as A2 was blank. Any other ideas? Alan wrote: In A2, =IF(A1="BTEC",1,IF(A1="AS",2,IF(A1="GCSE",3,"") )) Regards, Alan. Hi All, [quoted text clipped - 23 lines] Mary. -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
Hi Mary,
It does work. Enter the formula into cell A2. A2 will then be blank. Now enter BTEC into A1 and A2 will return 1. Similarly in A1, AS returns 2 and GCSE returns 3 in A2. Regards, Alan. "sike11 via OfficeKB.com" <u21678@uwe wrote in message news:6c843e21ee34e@uwe... Hi, Thanks for the suggestion. However, it did not work as A2 was blank. Any other ideas? Alan wrote: In A2, =IF(A1="BTEC",1,IF(A1="AS",2,IF(A1="GCSE",3,"")) ) Regards, Alan. Hi All, [quoted text clipped - 23 lines] Mary. -- Message posted via http://www.officekb.com |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
Hi Alan,
I have managed to resolve it!! You did point me in the right direction. Thank you. Mary. Alan wrote: Hi Mary, It does work. Enter the formula into cell A2. A2 will then be blank. Now enter BTEC into A1 and A2 will return 1. Similarly in A1, AS returns 2 and GCSE returns 3 in A2. Regards, Alan. Hi, [quoted text clipped - 10 lines] Mary. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
It's heart-warming to hear that you managed to resolve it all by yourself.
I'm humbly glad to have pointed you in the right direction. Regards, Alan. "sike11 via OfficeKB.com" <u21678@uwe wrote in message news:6c85e2758b90d@uwe... Hi Alan, I have managed to resolve it!! You did point me in the right direction. Thank you. Mary. Alan wrote: Hi Mary, It does work. Enter the formula into cell A2. A2 will then be blank. Now enter BTEC into A1 and A2 will return 1. Similarly in A1, AS returns 2 and GCSE returns 3 in A2. Regards, Alan. Hi, [quoted text clipped - 10 lines] Mary. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
see response to your posting in excel.misc
-- Regards Roger Govier "sike11 via OfficeKB.com" <u21678@uwe wrote in message news:6c83fbaeba87d@uwe... 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional IF statements
Better tackled with VLookup.
Create a 2 column array somewhere on your sheet like this Btec national 1 AS Economics 2 GCE maths 3 An put this formula =VLOOKUP(A1,H1:I3,2,FALSE) in B2 in the above case the array is in columns H & I rows 1 to 3. Adjust to suit. Mike "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional statements: how do I make reslts show up in dif cell | Excel Worksheet Functions | |||
| Conditional Statements | Excel Discussion (Misc queries) | |||
| combining conditional statements | Excel Worksheet Functions | |||
| Nesting IF statements, Conditional Formatting | Excel Discussion (Misc queries) | |||
| iF STATEMENTS WITHIN CONDITIONAL FORMATS | Excel Worksheet Functions | |||
Hybrid Mode
