Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Not sure why this formula does not work. I just want the value to be zero if 60-D15 is negative


also tried


Any clues?

share|improve this question
I've tried your approach: =MAX(60-B1, 0) and it works as it supposed to. See my file: goo.gl/3R5w5 – Jacob Jan Tuinstra Jan 11 '13 at 8:48
How does it 'not work'? E.g., what is the result of the formula in your spreadsheet? – Vidar S. Ramdal Jan 11 '13 at 9:54
Spreadsheet is in German locale (file, spreadsheet settings). The formula does work in UK locale. The result is #ERROR! ("Parse Error") – Keyo Jan 11 '13 at 11:22
Then you can try: =MAX(60-B1;0), Sorry didn't you own answer allready, that's the solution.... – Jacob Jan Tuinstra Jan 11 '13 at 11:57

German locale requires a ; instead of , as the argument separator in functions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.