Actually, I now see that just the AND function with the two eomonth functions shows the problem. Any thoughts?
As an aside, this was a valuable question for me to have asked since it caused me to realize that my formula, while valid (so my question still is worth addressing), was wrong in that, if the first IF were true, I would be dividing by 1000 twice, which was not my intent!
Dean
Actually, I started simplifying the function by repalcing complex functions from left to right and after I went only this far (put in the 6) , the problem went away!
=IF(1=2,3,IF(AND(U$7>=6,U$7<=EOMONTH(CostSpread!$G31,0)),CostSpread!$H31,0))/1000
Ok, it is below. Certainly, it is complex. I can tell you that I am not having the problem with another cell that has the same if/cell/override function combo, nor one that only has the eomonth function. Perhaps, combining the two is more than it can handle? Thanks Dean
=IF(CELL("TYPE",Override!U71)="V",Override!U71/1000,IF(AND(U$7>=EOMONTH(CostSpread!$E18,0),U$7<=EOMONTH(CostSpread!$G18,0)),CostSpread!$H18,0))/1000
Perhaps we could be of more help if you would copy/paste your formula(s) here.
--
Don Guillett
SalesAid Software
(e-mail address removed)
When I go to some cells in my file and hit F2, then F9, it shows #NAME?, even though the value shown in the cell itself is clearly Ok, such as 15.4, as well as another cell which sums this cell with other cells (and doesn't exhibit the aforementioned f2, f9 problem)?.
What are the possible causes of this?
