Sharepoint automatically adds a trailing zero to a currency in a sharepoint list

Hi there,

Furthur to earlier thread https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-automatically-adds-a-trailing-zero-to-a/4e41e967-3268-4853-8805-19b682992794?page=1

I am from India and still facing same issue. I have tried all the workarounds provided in above thread but none worked.

In my case the column is a calculated column with nested IF formula.  A single IF statement takes only 19 conditions until than it calculates value also correctly. But anything above 19 conditions it throws a generic value as Zero with out syntax error. If I add the & operator it calculates the value but adds additional zeros before and after the numbers.

Requesting help at the earliest as my project is stuck

Regards,

Avinash