IF statement Not working properly while using in calculated fields

Everytime i adding some some in calculated file d using IF statement it shows. Even my paranthesis are appropriate in no.

2 Likes

Could you please help with sharing the query you’ve written?

1 Like

Hey @g_t

You are getting this error because of an extra closing parenthesis ) or missing/misused parentheses in your formula.

For example, this is incorrect:

IF(A1 > 50, "Pass", "Fail"))

The correct formula should be:

IF(A1 > 50, "Pass", "Fail")