spreadsheet formulas

Hi everybody I have been using the following formula in Microsoft Office =IF(SUM(A1:B1) >C1,"CASTING ERROR","OK") does anybody know the same formula for use in Open Office please.

  MAJ 23:12 25 Jan 11

It's the same formula in OO except that you use a semicolon, rather than a comma, as a separator in the formula.

=IF(SUM(A1:B1) >C1;"CASTING ERROR";"OK")

Thankyou Maj for your help

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

New MacBook Pro 2017 release date, UK price and tech specs: Kaby Lake MacBook Pro to launch in…