Formulas no longer calculate

[phred]

I've been using OpenOffice for a few years now, in both Windows XP and Vista, and now in Ubuntu. I've converted most of my old Excel files to Calc files. In all this time I've never encountered a functional problem before.
I recently upgraded to Ubuntu 9.10 Karmic Koala and don't know if that has caused the problem or what.
After the upgrade a formula I'd been using for year's to calculate the age of friends and family, stopped calculating. The formula is =IF(C2=0,0,YEAR(NOW())-YEAR(C2)) Where C2 contains th DOB of the individual and used to return the age in B2. Now new entries don't calculate. If you change the DOB in an existing entry It changes the age in the corresponding Cell, but no new entry calculates at all. I'm experiencing this problem with all my spreadsheets and this is the simplest formula I use. My more complicated formulas include nested boolean statements that change with input and there's no hope of debuging them until I can fix this much simpler formula. The confusing part is why existing entries still work but new entries don't. Any ideas anyone?

[FJCC]

One of the first things to try when OOo is doing something weird is to reset your user profile as explained here.

[Cambirder]

=IF(C2=0,0,YEAR(NOW())-YEAR(C2))

Try changing those commas to semicolons

=IF(C2=0;0;YEAR(NOW())-YEAR(C2))

OpenOffice will import your formula from existing .doc documents without a problem, but if you are creating a new one you need to use semicolons.