1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Anarel [89]
3 years ago
11

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))

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.

You might be interested in
What is ment by creative middle way solution
SOVA2 [1]
Looking for a way to resolve conflicting values that comes as close as possible to satisfying all relevant obligation
7 0
3 years ago
80. A .......... is used to read or write data.<br>A. CD B. VDU C. ROM D. RAM​
Volgvan

Answer:

Depending on exactly what they mean by read and write, both A and D are valid.  In fact, if you read that as "read or write" as being a logical OR and not the logical AND that the sentence probably intends, then all four answers could be correct.

What they probably mean to say though is "..... is used as a read/write storage medium", in which case A is the correct answer.

A.  Data can be written to or read from a CD.  This is probably the "right" answer

B. A human can "read" data from a Visual Display Unit, and the computer "write" it.  That of course is not the intended meaning though.

C.  Data can be read from Read Only Memory, but not written to.

D. Data can be both read and written to Random Access Memory, but not retained after the computer is powered off.

8 0
2 years ago
.What particular skills does a team leader need in addition to the other skills needed by any team member. (choose all that appl
omeli [17]

Answer:

encourage and support team members

always keep a vision of the “big picture”

communicate frequently with team members

Explanation:

As a team leader, this is important to motivate and encourage team members to move on are especially needed during the hard time to face some challenges or solving some problems.

Besides, a vision of big picture from the team leader will assure the entire team that they are moving in a right direction to achieve a bigger goal despite they are facing a number of challenges/obstacle.

A team work need frequent communication to minimize misunderstanding and to ensure the job allocation and coordination running smooth as expected. A team leader plays the vital role to be proactive in communication with members to make sure every job arrangement are monitored and on track.

6 0
2 years ago
Running the cpu at a faster speed than the manufacturer recommends is called ________.
laila [671]
Overclocking is forcing the Central Processing Unit to run at a faster speed than the recommended manufacturer setting. While the CPU may function at a higher speed, it is not recommended because it could damage your CPU. 

Which would suck, since replacing that small chip tends to be costly.
5 0
3 years ago
write the structure of an email message ques.2 what do you mean by search engine? write its component .ques. 3 what are the adva
loris [4]

Answer:

1.....There is a standard structure for emails. Email contents are primarily classified as two, the header and the body. We are going to see the contents come under the two subparts. The email header gives us common details about the message such as the unique identity of the message.

Explanation:

2......a program that searches for and identifies items in a database that correspond to keywords or characters specified by the user, used especially for finding particular sites on the World Wide Web.

its components are ....

A search engine normally consists of four components e.g. search interface, crawler (also known as a spider or bot),indexer, and database.

3.....Advantages Of eLearning

It is a very efficient way of delivering courses online. Due to its convenience and flexibility, the resources are available from anywhere and at any time. Everyone, who are part time students or are working full time, can take advantage of web-based learning.

hope this will help you ..

please like and mark as brilliant.

4 0
3 years ago
Other questions:
  • You can access various sites on the WWW by using hyperlinks or by
    14·1 answer
  • Why might a government entity choose to offer some information and services online as in e-government
    8·2 answers
  • Ansel Adams education and special training
    14·1 answer
  • Implement a program to measure the impact of application-level buffer sizes on read time. This involves writing to and reading f
    13·1 answer
  • How many bits would be needed to count all of the students in class today there is 20 students
    6·1 answer
  • ¿Quién recibe la orden de ejecución de un programa enviada por el usuario?
    9·1 answer
  • Which of these lines of code will increment a variable?
    11·1 answer
  • Select the correct answer from each drop-down menu. What are the effects of emerging technology? has brought the internet to alm
    10·1 answer
  • PLS REPLY ASAP WILL MARK BRAINLIEST
    5·2 answers
  • 100 POINTS!!!!!!!
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!