An alternative to using several nested IF functions is to use a ____ table.
A)lookup
B)value
C)comparison
D)rating

Question

Quizplus · Accepted Answer

Using a lookup table allows for a more efficient and organized way to compare values and return corresponding results without having to use multiple nested IF functions. It also allows for easier updates and modifications as the table can be edited without having to edit the actual formula.

An Alternative to Using Several Nested IF Functions Is to Use