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
|