View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
monica
 
Posts: n/a
Default 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