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
Dominik [7]
3 years ago
10

"Dean wants a quick way to look up staff members by their Staff ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR

function. If the VLOOKUP function returns an error result, the text ""Invalid Staff ID"" should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.)"
Computers and Technology
1 answer:
Feliz [49]3 years ago
4 0

Answer:

ierror(VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE), "Invalid Staff ID")

Explanation:

Let me try as much as I can to explain the concept or idea of iferror in vlookup.

iferror have a typically function and result like an if else statement, its syntax is IFERROR(value,value _ if _ error), this simply means that if the the error is equal to value, value is returned if not, the next argument is returned.

Having said that, feom the question we are given,

let's substitute the value with vlookup function and add an else argument, it will look exactly this way;

IFERROR(VLOOKUP(),"Invalid Staff ID")// now this will set the message if vlookup cannot find the.

On the other hand using the values given, we will have;

ierror(VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE), "Invalid Staff ID")

You might be interested in
A variable that can be modified from anywhere within a program is called a?
larisa86 [58]
A - a global variable
6 0
3 years ago
Given five positive integers, find the minimum and maximum values that can be calculated by summing exactly four of the five int
Aloiza [94]

Using the knowledge in computational language in JAVA it is possible to write a code that  print the respective minimum and maximum values as a single line

<h3>Writting the code in JAVA:</h3>

<em>import java.io.*;</em>

<em>import java.util.*;</em>

<em>import java.text.*;</em>

<em>import java.math.*;</em>

<em>import java.util.regex.*;</em>

<em />

<em>public class Solution {</em>

<em>    public static void main(String[] args) {</em>

<em>        Scanner in = new Scanner(System.in);</em>

<em>        long sum = 0;</em>

<em>        long max = Long.MIN_VALUE;</em>

<em>        long min = Long.MAX_VALUE;</em>

<em>        for (int i = 0; i < 5; i++){</em>

<em>            long n = in.nextLong();</em>

<em>            sum += n;</em>

<em>            max = Math.max(max, n);</em>

<em>            min = Math.min(min, n);</em>

<em>        }</em>

<em>        System.out.println((sum - max) + " " + (sum - min));</em>

<em>    }</em>

<em>}</em>

See more about JAVA at brainly.com/question/12974523

#SPJ1

8 0
2 years ago
Which of the following is the MOST important consideration when planning your budget?
nata0808 [166]
<span>Budget for fixed expenses before flexible expenses.</span>
5 0
4 years ago
Read 2 more answers
Mm
Luba_88 [7]

Answer:

Print Area

Explanation:

First, I'll assume Donte is making use of a spreadsheet application (Microsoft Office Excel, to be precise).

From the given options, only "Print Area" fits the given description in the question.

The print area feature of the Excel software allows users to print all or selected workbook.

To print a selection section, Donte needs to follow the steps below.

Go to File -> Print.

At this stage, Donte will have the option to set the print features he needs.

Under settings, he needs to select "Print Selection"; this will enable him Print sections of the entire workbook.

Refer to attachment for further explanation

8 0
3 years ago
Which of the following statements is valid?SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Ven
vaieri [72.5K]

Correct Answer:

c.

SELECT InvoiceNumber, VendorName

FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID

WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)

Explanation:

All options only differ on the WHERE clause:

a: WHERE InvoiceTotal = MAX(InvoiceTotal)

Fails because aggregate functions (like MAX, COUNT, etc) have to be used on the SELECT clause.

b: WHERE InvoiceTotal = (SELECT MAX(InvoiceTotal))

Fails because the SELECT clause is incomplete.

c: WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)

This one is correct, and returns the InvoiceNumber and VendorName register with the largest value on the InvoiceTotal field.

3 0
3 years ago
Other questions:
  • A ____ paragraph places the first character of a text line near the left border of a placeholder.
    14·1 answer
  • The smallest unit of storage in the following list is a
    7·1 answer
  • When using an IDE, what must you do to use a class that's stored in a library? Select one: a. Nothing. Classes in libraries are
    11·2 answers
  • Develop a Python application that incorporates using appropriate data types and provides program output in a logical manner. You
    5·1 answer
  • You are hired by a game design company and one of their most popular games is The Journey. The game has a ton of quests, and for
    12·2 answers
  • Which output device would a teacher use to show
    13·1 answer
  • Write a script that checks to see if at least one argument has been given on the command line and tests whether the argument is
    5·1 answer
  • Who invented slide Rule and when?​
    7·2 answers
  • How long is prison time for someone who commits copyright infringement for the first time ?
    7·1 answer
  • 3. What of the following is the main components of computer system?
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!