All categories

3 years ago

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

Computers and Technology

1 answer:

cluponka [151]3 years ago

8 0

Answer:

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

=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.

You might be interested in

4.8% complete this is a single choice question; skip ahead to question content a b c d confirm difficulty level: moderate an int

PilotLPTM [1.2K]

Answer:

A replay attack

4 0

2 years ago

Consider the code fragment below (with nested loops). int sum = 0;for (int i = 1; i < 5; i++) for (int j = 1; j <= i; j++)

sammy [17]

Answer:

Option d is the correct answer for the above question.

Explanation:

The first loop of the program has a second loop and then the statement. In this scenario, the second loop executes for the value of the first loop and the statement executes for the value of the second loop.
The first loop executes 4 times, Then the second loop or inner loop executes n times for the n iteration of the first loop, for example, 1 time for the first iteration of the first loop, 2 times for the second iteration of the first loop and so on.
Then the inner loop executes (1+2+3+4) iteration which gives the result 10 iterations.
The sum initial value is 0 and the "sum++", increase the value of the sum by 1.
So the value of the sum becomes 10 after completing 10 iterations of the inner for loop.
Hence the 10 will be the output. So the Option d is the correct answer while the other is not.

3 0

3 years ago

4.15 LAB: Mad Lib - loops Mad Libs are activities that have a person provide various words, which are then used to complete a sh

Sergio039 [100]

Answer:

Following are the program in the Python Programming Language.

#set the infinite while loop

while(True):

#get string input from the user

name=input()

#get integer input from the user

num=int(input())

#set the if statement to break the loop

if(num==0):

break

#otherwise, print the following output

else:

print("Eating {} {} a day keeps the doctor away.".format(num, name))

Output:

oranges

Eating 5 oranges a day keeps the doctor away.

apple

Explanation:

Following are the description of the program:

Set the loop that iterates at infinite times and inside the loop.
Declare two variables which are 'name' that get string type input from the user and 'num' that get integer type input from the user.
Set the if conditional statement for break the infinite while loop.
Otherwise, it prints the following output.

7 0

3 years ago

Robots are increasingly being used in caring roles. Discuss the ethical and cultural implications of this trend

vekshin1

Using more robots means less human contact which means declining social skills, and heavier dependence on technology. And using more technology is expensive.

4 0

3 years ago

Consider the partially-filled array named a. What does the following loop do? (cin is a Scanner object)int[] a = {1, 3, 7, 0, 0,

boyakko [2]

Answer:

Option 1: May crash at runtime because it can input more elements than the array can hold

Explanation:

Given the code as follows:

int[] a = {1, 3, 7, 0, 0, 0};
int size = 3, capacity = 6;
int value = cin.nextInt();
while (value > 0)
{
a[size] = value;
size++;
value = cin.nextInt();
}

From the code above, we know the a is an array with six elements (Line 1). Since the array has been initialized with six elements, the capacity of the array cannot be altered in later stage.

However, a while loop is created to keep prompting for user input an integer and overwrite the value in the array started from index 3 (Line 4- 9). In every round of loop, the index is incremented by 1 (Line 7). If the user input for variable value is always above zero, the while loop will persist. This may reach a point where the index value is out of bound and crash the program. Please note the maximum index value for the array is supposedly be 5.

8 0

3 years ago