Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula problem
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.. |
#2
|
|||
|
|||
Quote:
record macro, make it run at the time of opening workbook. 1. start macro recorder 2. place the cursor in c60 3. hit the enter key as you did 4. stop the macro 5. copy the code into workbook_open event all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Odd Excel Formula Problem | New Users to Excel | |||
problem with excel formula | Excel Worksheet Functions | |||
Excel formula problem | Excel Discussion (Misc queries) | |||
Excel Formula Problem | Excel Discussion (Misc queries) | |||
EXCEL FORMULA PROBLEM | Excel Discussion (Misc queries) |