Almost all Functions in Numbers on MacOS Give Me Syntax Errors
Try using ; as a separator between parameters instead of ,.
If you start typing the function name in a cell and let it autocomplete you should also be able to see which separator will work and how the function should look.
It seems that in locales with a comma as a decimal point the separator for functions is different. The same thing happens in Microsoft Excel which is why I knew to look for it.