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 |
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 |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com