Nested IF function
 

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:

Nested IF function
 

"melissat" <u27986@uwe wrote in message news:67ea5e89ca118@uwe...
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

Nested IF function
 

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

"melissat" wrote:

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:

Nested IF function
 

=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","Kentu cky","Not Recognized")))))


"roadkill" wrote:

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

"melissat" wrote:

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:

Nested IF function
 

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

"JLatham" wrote:

=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","Kentu cky","Not Recognized")))))


"roadkill" wrote:

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

"melissat" wrote:

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:

Nested IF function
 

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.

--
Regards

Roger Govier


"Naveed Pathan" wrote in
message ...
what if someone have more than 8 nested IF function needed so than
..............................

"JLatham" wrote:

=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","Kentu cky","Not
Recognized")))))


"roadkill" wrote:

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

"melissat" wrote:

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: