Go to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology is planning to develop. Benicio wants to make sure the total expense per unit sold calculation in cell BIT does not produce a divide by zero error.
Modify the formula in cell B17 as follows:
a. Add the IFERROR function to the formula in cell d17.
b. Use "Divide total expenses by units manufactured" as the message to display
in case of an error.
davidap asked a year ago
Reading books is a great way to learn. Here are some of the books we recommend.
Click at B17 and enter =IFERROR(B16/B11, "Divide total expenses by units manufactured")
davidmacago answered a year ago