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

Monica is teaching herself to paint. What web resource would be the most helpful

strojnjashka [21]

Answer:

Video Tutorial

Explanation:

The others don’t make sense.

3 0

3 years ago

Los organos de los sentidos perciben de la misma manera un estimulo?porque?

xeze [42]

Espero que te ayude!!!!

3 0

3 years ago

Write a program that computes and displays a 15 percent tip when the

Anuta_ua [19.1K]

Your question wasn't very clear, but I think I understand what you want. Additionally, you should really state what language you're working with. Here it is in C#, and shouldn't be too much of a hassle to translate in to other languages.

Console.Write("Enter payment: ");

float payment;

if (float.TryParse(Console.ReadLine(), out payment))
Console.WriteLine((Math.Floor(payment * 100) / 100) * 0.15, + " at 15% tip.");
else
Console.WriteLine("Invalid input.");

5 0

3 years ago

You are configuring a network attached storage (nas) appliance. what file sharing protocol(s) could you use to allow access to w

kicyunya [14]

Most clients should support Server Message Block (SMB)/Common Internet File System (CIFS).

Common Internet File System (CIFS) is a network filesystem protocol used for providing shared access to files and printers between machines on the network. A CIFS client application can read, write, edit and even remove files on the remote server.

<h3>What are CIFS servers?</h3>

CIFS stands for “Common Internet File System.” CIFS is a dialect of SMB. That is, CIFS is a particular implementation of the Server Message Block protocol, created by Microsoft.

To learn more about Internet File System , refer

brainly.com/question/13008468

#SPJ4

6 0

2 years ago

Create a structure representing a student. The member variables should include student name, student ID, and four test grades fo

Neporo4naja [7]

Answer:

Output:

Name: Brainly

ID:0001

Write the 4 tests grades of the student separated by space :10 9 8 10

Brainly

0001

10 9 8 10

Average :9.66667

'1' to continue '0' to exit :

Explanation:

#include<iostream>

#include<string>

using namespace std;

//variables declaration

struct Student {

string id; //string declaration ID

string name; // string declaration name

int grades[4]; //array of 4 because it is 4 grades

};

//definition of the function get information

void inputData(Student &s){

cout << "Name:" ;

getline(cin,s.name);

cout << "ID:";

cin >> s.id;

cout << "Write the 4 tests grades of the student separated by space :";

for (int i = 0; i<4; i++)

cin >> s.grades[i];

}

//definition of the function of average

double inputAvg(Student s){

double summation;

int temporary;

double average;

for (int i = 0; i<4; i++){

for (int j = i; j<4; j++){

if (s.grades[j] > s.grades[i]){

temporary = s.grades[i];

s.grades[i] = s.grades[j];

s.grades[j] = temporary;

}

summation = 0;

for (int i = 0; i<3; i++){

summation = summation + s.grades[i];

}

average = summation/3;

return average;

}

void disp(Student *s){

cout << s->name << endl;

cout << s->id << endl;

for (int i = 0; i<4; i++)

cout << s->grades[i] << " ";

cout << endl;

cout << "Average :" << inputAvg(*s) << endl;

}

int main(){

Student st;

int ch;

while(true){

inputData(st);

disp(&st);

cout << " '1' to continue '0' to exit :";

cin >> ch;

if (ch == 0)

break;

}

return 0;

}

6 0

3 years ago