software

Good Afternoon,

Could someone please be of assistance. I am currently a new user and I am
having difficulty with quot;IFquot; 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,quot;Faculty of Artquot;,IF(A1=1300,quot;Faculty of
Designquot;,IF(A1=1700,quot;Liberal Studiesquot;,quot;quot;)))

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

quot;monicaquot; wrote:

gt; Good Afternoon,
gt;
gt; Could someone please be of assistance. I am currently a new user and I am
gt; having difficulty with quot;IFquot; statements.
gt;
gt; I am working on a spread sheet that has various departments:
gt; Art, Design, Liberal Studies, ect.
gt;
gt; I want to creat a statement that has the following:
gt; If 1000 then it should read faculty of Art
gt; If 1300 then it should read faculty of Design
gt; If 1700 then it should read liberal studies
gt; etc.
gt;
gt; I keep trying to do this but if keeps giving me error messages.
gt; I'm hoping someone can help.
gt; If statements can't be that complicated. Are they?
gt;
gt; Many Thanks
gt;
gt; Monica