Which function should be used to mask zero values in templates?
A)IF
B)IFERROR
C)VLOOKUP
D)INDEX

Question

Quizplus · Accepted Answer

IF and VLOOKUP can be used to perform different operations, but they do not specifically mask zero values in templates. INDEX can be used to select a specific range of cells, but it cannot automatically hide zero values. On the other hand, IFERROR can be used to display alternative values for errors, including zero values. Therefore, IFERROR is the best choice to mask zero values in templates.

Which Function Should Be Used to Mask Zero Values in Templates