If Statements- New User

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top