#135 Formula with IF function not work on zk but fine on excel.

[kwangcheol min]

Hi.
I have some problem using zk spreadsheet.
That is..

B4 : text
C4 : x
D7 : text with x or not contained x (ie, 10x20 or 100)
In above condition,
formular : =CONCATENATE($B$4,IF(ISERROR(FIND($C$4,LOWER(D7))),D7,LEFT(D7,FIND($C$4,LOWER(D7))-1)))
The formular caused error on zk spreadsheet when D7 doesn't contain x but ms excel is fine.

Someone help me about this issue?
Any help will be appreciated.
Thanks.