Which function will match multiple values and return the ...
Which function will match multiple values and return the first match in Excel?
IF()
IFS()
IIF()
SWITCH()
Correct answer is D
The SWITCH() function is used to match multiple values and returns the first match.
Syntax:
=SWITCH (expression, val1/result1, [val2/result2], ..., [default])
Example:
=SWITCH(G4,0,"Sun",1,"Mon",2,"Tue",3,"Wed",4,"Thu",5,"Fri",6,"Sat")
In MS Excel, the currently selected cell address is displayed in ____ ...
In MS Excel, 'Merge and Center' is used to ____ ...
When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that? ...
What is the extension of a Microsoft Excel file? ...
What symbol is used before a number to make it a label in Excel? ...
Cascade update option in Access ...