Logo
2

18. Go to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology.. Use "Divide total expenses by units manufactured"

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.

davidapdavidap asked a year ago

·

Answers

1

Click at B17 and enter =IFERROR(B16/B11, "Divide total expenses by units manufactured")

davidmacagodavidmacago answered a year ago

Post your answer

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.