Support Board

Date/Time: Tue, 21 May 2024 05:43:10 +0000

Post From: New spreadsheets not calculating properly?

[2015-12-22 17:48:12] Link To Thread - Link To Post [Go To First Post]
heavyhucks - Posts: 18
I have the following formula in cell x3: =if(u3<>"","",if(and(v3<>"",v4=""),small(d3:d33,1),if(x4<>"",x4,""))) Sometimes it fails to calculate, both on LIVE and on REPLAY (accurate mode or not). Now granted this is not the best bit of code, but I have never had problems with it in excel. I have tried substituting <>"" with the actual values I am looking for such as u3="short signal", but it still fails to calculate. The strange thing is, that if I click into the cell and then press enter, it will then calculate. However, Spreadsheet auto-calculate is ON! I have also tried altering the "on bar close" options to see if that was causing it to not calculate. Any ideas would be much appreciated.