Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below.
-Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.

Question

Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below.
-Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.
A) =SUM(B5:B9)<150 
B) =AND(B5:B9)<150 
C) =SUM(B5:B9)<>150 
D) =AND(B5:B9)<=150

Quizplus · Accepted Answer

The correct formula to check if the total purchases fall below $150,000 is =SUM(B5:B9)<150000. Option A is the closest match, but it mistakenly lacks the correct number (150000 instead of 150). The correct logic is to sum the range and then compare it to 150,000 to see if it's less.

Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas