View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 30
Default 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