If Statements- New User

[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

 

[Guest]

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