How to convert an Excel formula from English to Russian format?

C

Chichi2015-12-03 04:43:45

excel

Chichi, 2015-12-03 04:43:45

I have the following Excel formula:
=IF(LEFT(A1,FIND("/",A1)-1)="1","yes",IF(LEFT(A1,FIND("/",A1)-1)= RIGHT(A1,LEN(A1)-FIND("/",A1)),"yes","no"))
Russian version is needed.
While there is this option:
=IF(LEFT(A1,1)="1","yes",IF(LEFT(A1,FIND("/",A1)-1)=RIGHT(A1,LENG(A1)- DLSTR("/";A1)),"yes","no"))
Throws an error. What is the problem?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)