# How to simplify Calc formula?

In Excel, I have one formula:

=IF(AND(F287=G287,G287=H287), "-Ф-","")&
IF(AND(F287<>G287,F287<>H287,G287<>H287,
COUNTIF(F286:AP286,F287)>0,COUNTIF(F286:AP286,G287)>0,
COUNTIF(F286:AP286,H287)>0),A287-A286&"-ONE-","")&
IF(AND(F287<>G287,F287<>H287,G287<>H287,
OR(AND(COUNTIF(F286:AP286,F287)>0,COUNTIF(F286:AP286,G287)>0,
COUNTIF(F286:AP286,H287)=0),
AND(COUNTIF(F286:AP286,F287)>0,COUNTIF(F286:AP286,G287)=0,
COUNTIF(F286:AP286,H287)>0),AND(COUNTIF(F286:AP286,F287)=0,
COUNTIF(F286:AP286,G287)>0,COUNTIF(F286:AP286,H287)>0))),A287-A286&"---b","")&
IF(OR(AND(F287=G287,F287<>H287,COUNTIF(F286:AP286,F287)>0,
COUNTIF(F286:AP286,H287)>0),AND(F287=H287,F287<>G287,
COUNTIF(H286:AP286,F287)>0,COUNTIF(F286:AP286,G287)>0),
AND(F287<>G287,G287=H287,COUNTIF(F286:AP286,F287)>0,
COUNTIF(F286:AP286,G287)>0)),A287-A286&"---m-","-")


I want to shortcut that formula, or change with a shorter. Help me, please! Very thanks!

(Slightly edited for readability by @Lupp.)

edit retag close merge delete