Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |