How let the error message work?

[Romano_odK]

Good evening,
Made this formula, but I ran into this problem. I need the cell n5 to come up with and error message "GROSSIER" if (J5+L5)<((j5+l5)-N5);"GROSSIER"; but I can't get his to work. Is there a way to do this?

Thank you for your time,

Romano

=IFERROR(IFS(AND($M$3>0;$N$3>0);(J5*$M$3)/(100%-$N$3);
AND($K$3>0;$N$3>0);(J5+L5)/(100%-$N$3);
AND($M$3>0;N5>0);((J5*$M$3)/(100%-N5));
AND(K5>0;$N$3>0);((J5+L5)/(100%-$N$3));
AND($K$3>0;$M$3>0);"FOUT";
AND(K5>0;M5>0);"FOUT";
$K$3>0;(J5+L5)/(100%-N5);
K5>0;(J5+L5)/(100%-N5);
$M$3>0;(J5*$M$3)/(100%-$N$3);
M5>0;(J5*M5)/(100%-N5);
$M$3>0;(J5*$M$3)/(100%-N5));
(J5+L5)<((j5+l5)-N5);"GROSSIER";
"")

 

[6StringJazzer]

What result are you getting instead?

Are all the other conditions FALSE?

This formula doesn't mean much out of context. Can you provide sample data for us to try your formula and reproduce your result?

 

[Fluff]

It looks as though you have a bracket in the wrong place, also you don't need to use iferror if you are trying to prevent an error if there is no match.
Try

=IFS(AND($M$3>0;$N$3>0);(J5*$M$3)/(100%-$N$3);
AND($K$3>0;$N$3>0);(J5+L5)/(100%-$N$3);
AND($M$3>0;N5>0);((J5*$M$3)/(100%-N5));
AND(K5>0;$N$3>0);((J5+L5)/(100%-$N$3));
AND($K$3>0;$M$3>0);"FOUT";
AND(K5>0;M5>0);"FOUT";
$K$3>0;(J5+L5)/(100%-N5);
K5>0;(J5+L5)/(100%-N5);
$M$3>0;(J5*$M$3)/(100%-$N$3);
M5>0;(J5*M5)/(100%-N5);
$M$3>0;(J5*$M$3)/(100%-N5);
(J5+L5)<((j5+l5)-N5);"GROSSIER";
1;"")