Computers and Technology, 21.04.2020 19:31 BFBtrent

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: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 19:00

The fourth generation of computers emerged between 1970s and 1980s. which technological advancement brought about this generation of computers? which computer architecture was used most in this generation?

Answers: 3

Answer

Computers and Technology, 22.06.2019 22:20

Pp 4.1 design and implement a class called sphere that contains instance data that represents the sphere’s diameter. define the sphere constructor to accept and initialize the diameter and include getter and setter methods for the diameter. include methods that calculate and return the volume and surface area of the sphere (see pp 3.5 for the formulas). include a tostring method that returns a one-line description of the sphere. create a driver class called multisphere, whose main method instantiates and updates several sphere objects.

Answers: 1

Answer

Computers and Technology, 23.06.2019 19:00

Whose task it is to ensure that the product flows logically from one step to another?

Answers: 3

Answer

Computers and Technology, 24.06.2019 09:50

Create a string list. 2. use console.readline() to collect values of firstname, lastname, street, city, state, zip, save them to list. 3. write a simple linq statement, call method uppercasewords() to change first letter to uppercase. 4. create a foreach statment to display the information. public static string uppercasewords(string value) { char[] array = value.tochararray(); if (array.length > = 1) { if (char.islower(array[0])) { array[0] = char.toupper(array[0]); } } for (int i = 1; i < array.length; i++) { if (array[i - 1] == ' ') { if (char.islower(array[i])) { array[i] = char.toupper(array[i]); } } } return new string(array);

Answers: 3

Answer

You know the right answer?

I have been trying to work on this for a while now, and this is on excel

In cell H10, en...

Questions