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) iA5: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) iA5:F5 = int
C) A5:F5 = bin
D) A5:F5 >= 0

Quizplus · Accepted Answer

iA5:F5 = int is a constraint that forces the values in the range A5:F5 to be integers. This constraint should be deleted if the range must contain exact dollar amounts such as $500.25.

Which of the Following Solver Constraints Should You Delete If