Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?
A) A5:F5 = 500.25
B) A5:F5 = int
C) A5:F5 = bin
D) A5:F5 = 0

Question

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?
A) A5:F5 = 500.25
B) A5:F5 = int
C) A5:F5 = bin
D) A5:F5 >= 0

Quizplus · Accepted Answer

The constraint "A5:F5 = int" should be deleted because it requires the values in the range to be integers, which means it would not allow for exact dollar amounts such as $500.25. The other constraints do not conflict with the requirement for exact dollar amounts.

Which of the Following Solver Constraints Should You Delete If