Formula in cells

[cwng3]

Hi,

I found that some cells with formula in the spreadsheet cannot refreshed automatically. I have tried to press F9 and turn on the calculation to auto in option. But the value still cannot be refreshed. Finally, I need to press F2 -> Enter to force the excel to recalculate the cells. Is it a bug in Excel that mislead Excel regards be the cells without formula ?

 

[iggydarsa]

What kind of formulas are they? Simple arithmetic ones?

 

[cwng3]

Hi,

Just if statement.

Thx

 

[Joe4]

Do you have AutoCalc option turned on?

Can you post exactly what the formulas are?
And what is contained in the cells they are referencing?

 

[cwng3]

Hi,

I have try to turn on the auto calculation. Below is the expression and the GET_PRICE and GET_PRICE_Z is a addin from XLL provided by inhouse development team. These functions can work properly in other spreadsheet.

=IF(S34<>"",IF(S34>2,S34*0.01,GET_PRICE(EJ22,GET_PRICE_Z(EJ22,S34/100,A1:B2),C1:D2)),IF(J34="",J47,GET_PRICE(EJ22,J34,C1:D2)))

 

[Joe4]

I see nothing with the formula that would cause problems if the AutoCalc option is turned on. I suspect it has something to do with the Get_Price function and the AddIn.