Getting #NAME? as a result when dividing decimals in calc

I’m not sure if this is a bug. In a column, I have formatted it for USD with no decimals, only whole dollars. I input the following “=35/12” and as expected after entering this, I get $3 (since 35/12 is 2.91666). In another cell in the same column, I have “=15.50/12” but it returns “#NAME?” If I put “=15/12”, it returns normal $1 This decimal issue also occurs in other cells of the same column. It seems to happen only with decimal division. My locale is not US English. What am I doing wrong, or is this a bug? I can’t find this online here https://bugs.documentfoundation.org

You say your locale is not US English.
Is your locale’s decimal separator a period (dot)?

Formatting a cell is how to show its contents. When you are writing to a cell, Calc needs to understand what you wrote. It uses the cell’s formatting to see if what you entered matches the format; but if it does not (like in this case: =15.50/12 does not fit to a US number mask, which does not include any = or /), it starts interpreting the string using normal (locale-dependent) means. So - only your locale separators in formulas.

Translation: replace dot with comma. I.e.: don’t write 15.50, write 15,50.