zachlawrence97
zachlawrence97 zachlawrence97
  • 02-12-2019
  • Computers and Technology
contestada

What does C4 refer to in the function =MATCH(C4,earnings,-1)?
A. The search row
B. The named range
C. The lookup value
D. The match type

Respuesta :

l135134 l135134
  • 14-12-2019

Answer:

The match type

Explanation:

This command is used to find the smallest value from lookyp array that is larger than look up value. lookup value in lookup array.

This command is look like:

=Match (Lookup Value,lookup array, match type)

in given example

lookup value is C4, Lookup Array is earnings and -1 is match type.

due to -1,

this function find the value from earnings that is smallest in array but larger than C4.

Answer Link

Otras preguntas

!!!!!!ДАЮ 70 БАЛОВ!!!!!!!Эба короче история я не совершено летний (меньше чем 14) из Украины но сейчас в Англии как беженец первые 3-4 месяца войны мать с отцом
PLEASE HELP. (Find the area of park)
the midpoint of line segement AB is M(2,-2). if the coordinates of A are (5,-6), what are the coordinates of B?
what is the type of introduction of lebanon's drinking water​
Handwritten solution required
Why are the American people saying that since the 2020 election, American democracy is gone?
5x-4y=17 2x-3y=11 Solve with elimination method
5. Convex mirror a)Converges the beam of light after reflection b)Diverges the beam of light after reflection c)Reflects the beam of light parallel d)None of th
What is 840 divided by 11???
What is the fourth term of ( 3x + y ) ^4