Hi All,
I am facing the following problem in excel.
I have a formula
IF(NOT(ISERROR(C54/C57)),C54/C57,"---") in cell C60 of a spreadsheet.

Now when the sheet opens up, I see a --- in C60 even if C54/C57 is not in error.

I know that for a fact because if I manually go on cell C60, go to the formula bar, press enter, it calculates the value correctly.

Just as a side note, the formula comes to the excel sheet via a java bean.

Any help would be appreciated..