Conditional format formula missing opening/closing parenthesis error

[valmir]

Hello everyone,
As the title says, this formula is missing a parenthesis. I have no clue where. Please help! I'm surprised I got this far with this formula by myself .
=IF(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);TRUE;IF(SUM(K4:L4)>SUM(K5:L5);TRUE;IF(OR(K4<>"Đ";L4<>"Đ");TRUE;FALSE))
Originally I had the formula like this:
=IF(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);TRUE;IF(SUM(K4:L4)>SUM(K5:L5);TRUE;FALSE))
And now I'm trying to add that third condition
Thanks

 

[DanteAmor]

The last one is missing:

=IF(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);TRUE;IF(SUM(K4:L4)>SUM(K5:L5);TRUE;IF(OR(K4<>"Đ";L4<>"Đ");TRUE;FALSE)))

But I'm going to try it to see if it can be simplified.

 

[valmir]

The last one is missing:

=IF(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);TRUE;IF(SUM(K4:L4)>SUM(K5:L5);TRUE;IF(OR(K4<>"Đ";L4<>"Đ");TRUE;FALSE)))

But I'm going to try it to see if it can be simplified.

ok

 

[johnnyL]

How about:

=IF(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);TRUE;IF(SUM(K4:L4)>SUM(K5:L5);TRUE;IF(OR(K4<>"Đ";L4<>"Đ");TRUE;FALSE)))

Edit: Dang my connection must be slow today.

 

[DanteAmor]

Conditional format formula

As the title says

If the formula is for conditional formatting, then IFs are not needed, it can be like this:

=OR(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);SUM(K4:L4)>SUM(K5:L5);OR(K4<>"Đ";L4<>"Đ"))

 

[valmir]

=OR(AND(SUM(K4:L4)=SUM(K5:L5);L4>K5);SUM(K4:L4)>SUM(K5:L5);OR(K4<>"Đ";L4<>"Đ"))

It works perfectly. Thank you so much!