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: