FORMULA PROBLEMS READING EXCEL FILES

[Donald McLean]

Hi, Good folks at Apache, I’m having trouble that a formula [ =IF(B1<0, 
"-",SUM(A1-B1)) ] which works fine in Excel, translates as an Error 509 
whatever that is. In trying to correct it I find that Apache OneOffice on a Mac 
won’t process the maths concept < or > any number, e.g. =IF ( b1<0, 3,4) won’t 
evaluate - I get the error ERROR 508. Can you please help, Kind Regards Don 
McLean