1

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?

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

1 Answer 1

4

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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