Two calibration equations use the same two unknowns: 3x + y = 11 and 2x + 4y = 14. Check their coefficient matrix before trying to solve them.

Keep the right-hand totals out of the matrix

Enter 3 and 1 in B2:C2, and 2 and 4 in B3:C3. Put 11 and 14 beside the matrix for reference. Enter =MDETERM(B2:C3) in E2. Expect 10, from 3 × 4 − 1 × 2. The nonzero result means there is one solution. As a check, x = 3 and y = 2 satisfy both equations.

The equations 3x + y = 11 and 2x + 4y = 14 are separated into coefficients and right-hand totals.

Example setup. Pass only the square coefficient block to MDETERM.

Try a dependent pair in a copy

Change the second coefficient row to 6 and 2. The determinant becomes zero. With a right-hand total of 22, the new equation is just twice the first and there are infinitely many solutions. With a total of 23, the two equations conflict. Both outcomes lack a unique solution.

The determinant 10 is contrasted with a zero determinant after the second coefficient row is doubled from the first.

Example control. A zero determinant establishes that the solution is not unique.

If your coefficients come from rounded measurements, a very small nonzero determinant can make the answer sensitive to small input changes.

Microsoft’s MDETERM function reference.