Support Board
Date/Time: Thu, 16 Jan 2025 19:51:43 +0000
[Programming Help] - Problem formula getting ARGS! sporadic
View Count: 1232
| [2017-11-15 23:34:52] |
| GiantAvocado - Posts: 67 |
|
Anyone see a problem with this formula? I am getting the ARGS! sporadically down the column & creates ARGS! on dependent cells? This does some math on some constants in the $ cells, I must be missing something simple here, but am brain numb now. =IF(AH3>0, IF(AH3<$Cq$3,3, IF(AH3<$Cp$3,(AH3-$Cp$3)/$CS$3, IF(AH3<$Co$3,(AH3-$Co$3)/$Cr$3, IF(AH3>=$Co$3,AH3/$Co$3)))),0) |
| [2017-11-16 01:52:58] |
| GiantAvocado - Posts: 67 |
|
I might add this formula and all the others that are getting ARGS!, including the framework tests perfect in Excel 2007 & 2016. So, maybe is there a difference in the "if" function?
|
To post a message in this thread, you need to log in with your Sierra Chart account: