The syntax of the IF-function is always given as
=IF(Column1<=Column2, "OK", "Not OK")
(Note the semicolons instead of the commas!)
=IF(Column1<=Column2, "OK", "Not OK")
However using the function like that causes a syntax-error.
The correct syntax is
(Note the semicolons instead of the commas!)
It took me about an hour fiddling with different formulas until I tried out the semicolons by accident and – surprise, surprise – suddenly it worked!
I hope this blog entry prevents you from falling into the same trap
