spreadsheet formulas

  [email protected] 22:00 25 Jan 2011
Locked

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 2011

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")

  [email protected] 23:37 25 Jan 2011

Thankyou Maj for your help

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Graphic tees: 14 best websites to find your next T-shirt

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017