Support Board
Date/Time: Sat, 28 Dec 2024 20:31:56 +0000
Post From: New spreadsheets not calculating properly?
| [2015-12-22 17:48:12] |
| 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. |