Thread: 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

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