Hi,

first time I’m posing a question on libre office Calc

so I got this formula

=IFERROR(IF(AND(FIND("$4";FORMULA(B5))>0;B5>0;A5*C$4;FIND(“A”&ROW(A5);FORMULA(B5)));“Super”;“Not OK”);“Not OK”)

which gives me an error??

But if I take the formula (in G5) (gives an error)

=IF(AND(FIND("$4";FORMULA(B5))>0;B5>0;A5*C$4;FIND(“A”&ROW(A5);FORMULA(B5)));“Super”;“Not OK”)

and I go to the next column (H5)

=IFERROR(G5;“Not OK”)

it gives me Not OK as a result??

Should be the same for the first formula ?

A5 contains the number 2, C4 contains 7,5 and B5 contains =C$4*A5 (which gives a correct result but if I change it to =C$4*C5 (which is empty) the first formula gives #Value as an error

The splitted formulas gives first error (OK for me) and then Not OK trapped by the IFERROR on G5??

Any ideas?

Thanks