I am no longer able to enter an IF function - I simply get the message "the formula typed contains an error". Existing IF functions still work but can't be edited. If I open the workbook with OpenOffice, enter the IF functions and save to Excel then it works - but still can't edit the formula from Excel. I have tried uninstalling Ms Office and reinstalling but problem persists. Anyone any idea what has gone wrong.