LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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:

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Nested "If" Function Ms. P. Excel Worksheet Functions 8 August 19th 05 07:31 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Countif Function -Nested Angi Excel Discussion (Misc queries) 7 May 4th 05 07:04 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"