Nested IF function

[melissat]

I have this homework that I have been having trouble with and no body has
been able to help me. Maybe you can!!

Heres the directions:
Start excel and enter this IF function in cell B1 and then use the fill
handle to copy the function down through cell B7. Enter the following data in
the cells in the range A1:A7 and then write down the results in cells B1
through B7 for each set.
Set 1: A1=IL;A2=IN;A3=IN;A4=OH;A5=IN;A6=OH;A7=IN.

Set 2: A1=WI;A2=KY;A3=IN;A4=IL;A5=IN;A6=IN;A7=OH.

Set 1 Results:

Set 2 Results:

 

[Beege]

I have this homework that I have been having trouble with and no body has
been able to help me. Maybe you can!!

Heres the directions:
Start excel and enter this IF function in cell B1 and then use the fill
handle to copy the function down through cell B7. Enter the following data
in
the cells in the range A1:A7 and then write down the results in cells B1
through B7 for each set.
Set 1: A1=IL;A2=IN;A3=IN;A4=OH;A5=IN;A6=OH;A7=IN.

Set 2: A1=WI;A2=KY;A3=IN;A4=IL;A5=IN;A6=IN;A7=OH.

Set 1 Results:

Set 2 Results:

..... but there's no IF function here....

Beege

 

[Guest]

What is the IF function that you are supposed to enter?
Will

 

[Guest]

=IF(SomeoneGivesAnswer,Grade_A,Grade_F)
??
I'm betting the formula in B1 might look something like this
=IF(A1="IL","Illinois",IF(A1="IN","Indiana",IF(A1="OH","Ohio",IF(A1="WY","Wyoming",IF(A1="KY","Kentucky","Not Recognized")))))

 

[Guest]

what if someone have more than 8 nested IF function needed so than
...............................

 

[Roger Govier]

Hi

There are usually better ways of dealing with large numbers of IF
statements, with functions like Lookup, Vlookup, Choose etc. but there
are also some techniques for getting around the 7 levels.

Take a look at Chip Pearson's site
http://www.cpearson.com/excel/nested.htm

If you want to try other methods, post back with the formula you are
using and an outline of the data that is being tested and maybe someone
can come up with an alternative for you.