Get End of expression expected error when write cell with formula

Help Activities
, ,
1

pls help to see the capture screen, may I know what’s wrong, this formula is fine in excel.

1
1709×259 9.97 KB

2

Hi,

Can you try the following?

"=IF(ISNUMBER(SERACH(""-2146826246"",J2)),K2,J2)"

Note: Doublequote should be expressed as "" in String literal (VB.net)

Regards,

1 Like
3

thanks, yes, it can work.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.