Excel Problem

A

Angell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if the numbers in sequence 11
Average Question 2
Nested IF function 5
Not so simpel copying of a simple formula 5
Excel formula 5
Macro to add Multiple rows in same sheet 1
Blank Cells 3
Need to obtain sum of last X entries that are greater than 0 2

Top