- Joined
- Jul 5, 2010
- Messages
- 1
- Reaction score
- 0
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..
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..