I have been trying to work on this for a while now, and this is on excel In cell H10, enter an INDEX function that will use a

3 answers
Question:

I have been trying to work on this for a while now, and this is on excel
In cell H10, enter an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C (C10), and use the Reason field in column B (B10) as the row number to return for the department name in the referenced named range.
Nest the function inside an IF function so that issues currently displaying as a 0 will display as a blank cell. Resize the column width as needed.
** I got this much of the formula
=INDEX(INDIRECT("Dept"),Reason)
but it only recalls and displays the Dept column contents. I need it to recall the Dept and display the Reason, I think? Then at that point, how would I get this into an IF statement?
I feel like I dont understand the instructions, and I know I am not that great on excel.

Answers

=IF(INDEX(INDIRECT(C10), B10)=0,"",INDEX(INDIRECT(C10), B10))

Or

=IF((INDEX((INDIRECT(Dept,TRUE)),Reason))="","",(INDEX((INDIRECT(Dept,TRUE)),Reason)))

Explanation:

Given

Your formula:.

=INDEX(INDIRECT("Dept"),Reason)

Dept column = C (C10)

Reason field = B (B10)

The issue with your formula is that you failed to include a statement to test the falsity of the first condition; in other words, if your if statement is not true, what else should the formula do.

The question says that

"Nest the function inside an IF function so that issues currently displaying as a 0 will display as a blank cell" this means that

if the INDEX() function returns 0, a blank should be displayed in H10 blank, instead.

So, the right formula both of these two. You can use any of them

1. =IF(INDEX(INDIRECT(C10), B10)=0,"",INDEX(INDIRECT(C10), B10))

2. =IF((INDEX((INDIRECT(Dept,TRUE)),Reason))="","",(INDEX((INDIRECT(Dept,TRUE)),Reason)))

The two does the same function; the only difference is that

(1) considers the cell itself while (2) considers the contents of the cell.

The analysis of both is that

They both use a nested indirect reference to check for the content of cells displaying 0.

The first if checks for the above mentioned; if yes, cell H10 is made to display a blank else it's original content is displayed.

answer; i believe the correct answer is : communicate safe work practices;

When setting up a domain controller in a remote branch office

Similar Solved Works

2 answers

A square room has a tiled floor with 81 square tiles. How many tiles are along an edge of the room?

A square room has a tiled floor with 81 square tiles. How many tiles are along an edge of the room?...
3 answers

Which of the following best supports the inference that the speaker is having a difficult time forgetting

Which of the following best supports the inference that the speaker is having a difficult time forgetting his love? a. and this maiden she lived with no other thought / than to love and be loved by me. b. for the moon never beams without bringing me dreams / of the beautiful annabel lee; c. that t...
10 answers

Rectangle ABCD has vertices at A(−3,1),B(−2,−1),C(2,1), and D(1,3). What is the area, in square

Rectangle ABCD has vertices at A(−3,1),B(−2,−1),C(2,1), and D(1,3). What is the area, in square units, of this rectangle? A 5 B 10 C 25 D 100...
4 answers

In what ways do macbeth's strengths contribute to his downfall?

In what ways do macbeth's strengths contribute to his downfall?...
3 answers

The Navy Pier Ferris Wheel in Chicago has a circumference that is ​56% of the circumference of the first Ferris wheel built in 1893.

The Navy Pier Ferris Wheel in Chicago has a circumference that is ​56% of the circumference of the first Ferris wheel built in 1893. the circumference of the Navy Pier Ferris Wheel is 439.6 ft. What was the radius of the first Ferris wheel? If someone could help me with this question it would be r...
9 answers

What is the [oh-] in a solution with a poh of 11.25

What is the [oh-] in a solution with a poh of 11.25...
10 answers

Can someone help me with my last question.

Can someone help me with my last question. [tex]Can someone help me with my last question.[/tex]...
1 answer

Ian is a teacher and takes home 46 papers to grade over the weekend. He can grade at a rate of 11 papers per hour. Write a recursive

Ian is a teacher and takes home 46 papers to grade over the weekend. He can grade at a rate of 11 papers per hour. Write a recursive sequence to represent how many papers Ian has remaining to grade after working for n hours....
10 answers

Which type of macromolecule is made of amino acids

Which type of macromolecule is made of amino acids...
4 answers

Me with this question *if your in family and community service, me with these questions *

Me with this question *if your in family and community service, me with these questions * [tex]Me with this question *if your in family and community service, me with these questions *[/tex]...
4 answers

Yokohama walks from home to buy stock at an average speed of 5 km/h humidity go on his school bus and traveled at an average speed

Yokohama walks from home to buy stock at an average speed of 5 km/h humidity go on his school bus and traveled at an average speed of 60 km/h until he got to school a total distance from his home to school is 35 km and the entire trip took a 1.5 hours...
4 answers

Charles charges $25 per lawn to mow lawns. If 25x represents the amount of money he earned last week, what does x represent?A: how large

Charles charges $25 per lawn to mow lawns. If 25x represents the amount of money he earned last week, what does x represent? A: how large each lawn was B: the total money he earned C: the number of lawns he mowed D: the amount he charges for each lawn...
5 answers

Am I doing this correctly getting answers of PowerPoint. Is the continent correct ?

Am I doing this correctly getting answers of PowerPoint. Is the continent correct ? [tex]Am I doing this correctly getting answers of PowerPoint. Is the continent correct ?[/tex]...
4 answers

Part C: Balance each of the following equations following the procedure described in class. Be sure to show your work.

Part C: Balance each of the following equations following the procedure described in class. Be sure to show your work. [tex]Part C: Balance each of the following equations following the procedure described in class. Be sure[/tex]...
4 answers

Why was Lincoln concerned he would not win re-election? (What were some of the criticisms of his decisions as president?) (Give at

Why was Lincoln concerned he would not win re-election? (What were some of the criticisms of his decisions as president?) (Give at least 3)...
3 answers

What is the molar mass of CH3OH

What is the molar mass of CH3OH...
1 answer

Derive the formula for the kinetic energy of an object of mass m, moving with velocity v​

Derive the formula for the kinetic energy of an object of mass m, moving with velocity v​...
4 answers

Look carefully at the face of an old person or a very young person. By studying the face, is there anythingyou can say about the person's character?

Look carefully at the face of an old person or a very young person. By studying the face, is there anything you can say about the person's character? What tells us whether a person is short-tempered, shy,playful, angry or happy?When you have made some points about the face, write a short descriptio...
4 answers

1750 to 1850 there was also a new movement occurring in art and literature called what

1750 to 1850 there was also a new movement occurring in art and literature called what...
4 answers

Two office buildings are 300 feet apart. The taller building is 800 feet tall. The angle of depression from the observation deck (top)

Two office buildings are 300 feet apart. The taller building is 800 feet tall. The angle of depression from the observation deck (top) of the taller building to the top of the shorter building is 15 degrees. How tall is the shorter building....

-- 0.013748--