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.

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