IF statement with text field isn't possible?

Question

Trying to do formula =IF([FIELD1]=[FIELD2],1). When I try to save the formula it gives me syntax error. Is it possible to achieve this with text?

The reason behind that is if texts match it would give 1 if doesn't then 0 after I would be calculating =SUM([Fields]).

Update:

I got a new problem now. Trying to separate text from numbers.

The Formula I am using:

=LEFT(Antraštė);SUM(LEN([Antraštė]-LEN(SUBSITUTE([Antraštė];{"0";"1";"2";"3";"4";"5";"6";"7";"8";"9"};"""))))

and it keeps getting syntax error.

The problem was with comma instead of =IF([Field1]=[Field2], 1) I had to write =IF([Field1]=[Field2]; 1) that fixed it — Lukas Šliužas, Feb 08 '19 at 14:07

score 2 · Accepted Answer · edited Feb 09 '19 at 03:29

2

Basic syntax for IF statement in calculated formula is:

IF(logical_test,value_if_true,value_if_false)

So, try to write down your formula in above format.

Note:

Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).

For detailed information and references check my answer given in below link:

Sharepoint online list, calculated value not working

edited Feb 09 '19 at 03:29

Joe McShea

1,515
9
15

answered Feb 08 '19 at 15:47

Ganesh Sanap - MVP

44,918
21
30
61

I found out that myself but thank you for informative response – Lukas Šliužas Feb 11 '19 at 06:18

IF statement with text field isn't possible?

1 Answers1

Linked