To return a negative value, ____ is a correct formula.
A) =-HLOOKUP(F14,I$7:K$9,3,TRUE) *H14
B) =(NEGATIVE) HLOOKUP(F14,I$7:K$9,3,TRUE) *H14
C) =(0) HLOOKUP(F14,I$7:K$9,3,TRUE) *H14
D) none of the above
Correct Answer:
Verified
Q38: In VLOOKUP, if a type FALSE is
Q39: You use VLOOKUP when _ of the
Q40: The syntax of the INDEX function is
Q41: In a VLOOKUP function, the argument _
Q42: In a FALSE VLOOKUP, if an exact
Q44: When creating a range for use with
Q45: A VLOOKUP table can have _ key
Q46: When solving an HLOOKUP formula, Excel looks
Q47: To find and retrieve data from a
Q48: In a VLOOKUP function, the argument _
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents