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.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017