VALUE() function behavior
The VALUE() function bahaves differently than in Excel
Excel
=VALUE("2-4,1")=#VALUE!
=VALUE("2-4;1")=#VALUE!
Zoho Sheets
=VALUE("2-4,1")=36926
=VALUE("2-4;1")=#VALUE!
Where on earth does 36926 come from? Does the coma present issues in other formulas?