Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Nested "If" Function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Countif Function -Nested | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |