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.
-Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.

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.
-Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.
A) =B10<150 
B) =SUM(B10)<150 
C) =AND(B10)<150 
D) =B10>150

Quizplus · Accepted Answer

The formula should be set up to check if the value in cell B10 is less than 150,000. Option A is the correct syntax for this.

Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas