migrating to Open Office Calc 2.4 to 3.0 – tip!

very quick one, if you are running logical IF statements in open office Calc 3.0 (soon to be rolled out with Ubuntu Jaunty Jackalope 9.04 I guess), the syntax has changed.

IF (A1>B1;”true”;”false”) was correct in v2.4, but returns a 508 error in v3.0

it it now

IF (A1>B1,”true”,”false”)

replace the semi colon with a comma is the simple trick, but it took me a while to find this out!