Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Excel Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Angell - 26 Jul 2006 00:04 GMT
It's for a Nested Function.

Enter this function in cell B1 and then use the fill in 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

not sure how nested functions work, if someone could tell me how to do
this one i should be ok to figure it out from here. thanks

Signature

Angell

davesexcel - 26 Jul 2006 01:21 GMT
check out custom lists

goto
tools
options
custom list

Signature

davesexcel

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.