Not sure why this formula does not work. I just want the value to be zero if 60-D15 is negative
=MAX(60-D15,0)
also tried
=MAX(D15,0)
=MAXA(D15,0)
Any clues?
Google-sheets – Google Docs Spreadsheet – Parse Error
google sheets
Related Topic
- Google-sheets – Spreadsheet parse error
- Google-sheets – Google sheets formula returning “Formula parse error”
- Google Sheets – Multiple IF Statements with ISDATE and THEN Formula
- Google-sheets – Google Sheets Sumif Formula Parse Error
- Google-sheets – Formula Parse error
- Google-sheets – how to use MAX in a query and use the result as a number in Google Sheets
Best Answer
German locale requires a ; instead of , as the argument separator in functions.