Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

What is wrong with this code?

= IF (F3+E3+D3 > 0, F3+E3+D3, 0)

I want the cell to contain the sum only if it is positive. If it is negative I want zero to be there.

Google Spreadsheet gives me error: Parse error.

share|improve this question

migrated from superuser.com Oct 19 '13 at 7:46

This question came from our site for computer enthusiasts and power users.

    
The function's working fine for me. I copied and pasted it into Google Spreadsheet without making any changes to it. There doesn't seem to be anything wrong with it from my perspective. –  Yassar Oct 17 '13 at 13:17
add comment

1 Answer 1

up vote 4 down vote accepted

Have you tried to use ";" instead of "," ?

share|improve this answer
    
Yes, it works. But why does all the documentation mention ","? –  Josef Sábl Oct 17 '13 at 13:44
    
I have no idea, normally it is used ";" in this expressions –  Ale Oct 17 '13 at 13:49
    
Probably some mess with the locales. In my country we use "," as decimal separator so 1,2,3,4 could be interpreted as either 1.2, 3.4 or 1, 2, 3, 4. Google, come on!? –  Josef Sábl Oct 18 '13 at 15:00
2  
@Josef The standard used by Google stipulates that ; must be allowed, but that , can be used. Due to the locale issues you mentioned, the comma won't work in locales where the decimal separator is a comma. On the other hand, semi-colons will work in any locale. Unfortunately the docs seem to have been written by someone in the US (or UK, Australia etc) and they chose to use the comma. They have been informed, but Google issue resolution is a slow, mysterious beast. –  Tom Horwood Oct 21 '13 at 0:46
add comment

Your Answer

 
discard

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