You developed a sales quotation workbook that you will share with your sales staff to help them quote prices. It shows #DIV/0 in some cells where there are empty quantities in a column. Which function would handle the error and replace it with another value?

A. ERRRORRETURN
B. IFERROR
C. ERRORHANDLER
D. ERRORTRACK


Answer: B

Computer Science & Information Technology

You might also like to view...

On a social network, metadata measures how frequently and deeply users interact with one another on the site

Indicate whether the statement is true or false

Computer Science & Information Technology

If bulk candy costs $10.00 a kilogram, how much will 3 pounds cost? (There are 2.2 pounds in a kilogram.)

Let x equal what you are trying to find x = ($ / purchase) Note: The unit "purchase" is made up.

Computer Science & Information Technology

A(n) __________ is defined by an equation in two variables with coefficients.

A. abelian group B. binary curve C. cubic equation D. elliptic curve

Computer Science & Information Technology

The command to switch from remote host screen to telnet screen is:

a: switch b: Ctrl-] c: [Esc] (Escape key) d: s e: [Return]

Computer Science & Information Technology