In cell B4, Marcia inserted the formula = (B1+B2)/B3.To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.
Correct Answer:
Verified
Q93: When you use a named range in
Q94: When you name a range, you can
Q95: Which dialog box do you use to
Q96: Loralie wants to protect her Excel spreadsheet
Q97: You use the SUMIFS function to sum
Q99: An error message is displayed in cell
Q100: Lydia entered row titles in the range
Q101: You can set only one language as
Q102: To show a comment attached to the
Q103: To provide suggestions to other people using
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents