how can i check if a cell is equal to summation of other cells?

Question

MAHMOUD ALZIOUD 2018-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/379010-how-can-i-check-if-a-cell-is-equal-to-summation-of-other-cells

评论： MAHMOUD ALZIOUD 2018-1-25

Dear All, I have a matrix of 5 columns and many rows, the first column A is the total weight of a car, the rest of the four columns are the individual weight each wheel carries, as a quality check, I need to check if every cell in the 1st column is really equal to the summation of the last four columns B to E, and if not delete this row because it will corrupted data, how can I do that in matlab? is there any (is equal) thing?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

the cyclist 2018-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/379010-how-can-i-check-if-a-cell-is-equal-to-summation-of-other-cells#answer_301770

编辑：the cyclist 2018-1-25

在 MATLAB Online 中打开

One should not check floating-point numbers for exact equality, due to possible error in exact representation. Here is a simple method that will check for equality within a tolerance you define.

% The data
M = [3 1 2;
     4 1 3;
     6 1 4];
% Define a tolerance for equality
tol = 1.e-6;
% Test for equality within tolerance
abs(M(:,1)-sum(M(:,2:end),2)) < tol;