Hi,
I have problem with "if with many conditions"

Image1 - conditions with equal - resultat error
Image2 - conditions with not equal - resultat OK


How to fix a formula?

Файл не найден.Файл не найден.Файл не найден.

It is not very clear what you want to achieve.
Compared to your procedure the two results are correct (but I'm afraid they are not the ones expected).
The procedure passes all rows of the Matrix and compares three elements. In the first case ( = ) at the first step the three equalities are verified but at the following steps no for which F1 is stored F1:=0 (correctly).
In the second case (not =) at the first step, the three inequalities are not verified, but the subsequent steps in the three inequalities are all verified, but in F1 is only stored the last of the values that replaces the previous calculated for rows 2 and 3 (correct).

sergio

The example with (not =) is irrelevant. Shows that the entire formula is correct.

I need to get the correct result in the second formula (=)

For this case the result should be 11 (first row meets the condition), not zero car first F1 = 0 + 22/2 = 11
This formula works for (not=) and not for (=)

look at this setting; it doesn't make much sense to do this but maybe it can help you understand SMath's behavior
sergio

Hello

This solves your problem



Test _CBG.sm (9 КиБ) скачан 20 раз(а).

Best Regards

Carlos

Thank you very much

All in all, I need the sum of this new matrix (F). And I did it like below



Thanks again for your help