Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statements- New User
Good Afternoon,
Could someone please be of assistance. I am currently a new user and I am having difficulty with "IF" statements. I am working on a spread sheet that has various departments: Art, Design, Liberal Studies, ect. I want to creat a statement that has the following: If 1000 then it should read faculty of Art If 1300 then it should read faculty of Design If 1700 then it should read liberal studies etc. I keep trying to do this but if keeps giving me error messages. I'm hoping someone can help. If statements can't be that complicated. Are they? Many Thanks Monica |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statements- New User
What you've described is a nested IF statement. It would look something like
this (assuming your lookup value is stored in A1): =IF(A1=1000,"Faculty of Art",IF(A1=1300,"Faculty of Design",IF(A1=1700,"Liberal Studies",""))) If you have 9 or fewer possible results, then Nested IF Statements will work for you. If you have more than 9 possibilities, then you should look into using the VLOOKUP function. HTH, Elkar "monica" wrote: Good Afternoon, Could someone please be of assistance. I am currently a new user and I am having difficulty with "IF" statements. I am working on a spread sheet that has various departments: Art, Design, Liberal Studies, ect. I want to creat a statement that has the following: If 1000 then it should read faculty of Art If 1300 then it should read faculty of Design If 1700 then it should read liberal studies etc. I keep trying to do this but if keeps giving me error messages. I'm hoping someone can help. If statements can't be that complicated. Are they? Many Thanks Monica |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Charting - User Selected Data Lines | Charts and Charting in Excel | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Finding a record based on user input | Excel Discussion (Misc queries) | |||
Positioning 2 User Forms | New Users to Excel |