I have a workbook that is not calculating cells unless I manually click on them.
Yes automatic calc is on, and I have tried the text to columns trick. I think it has something to do with timing of the value of a cell during recalc.
I have the following formula that works just fine: -PL(Variables!$B$18,Variables!$B$12,B$2-7,B$2-7,"i","i","i","i","i","i"))
This is a custom add in that basically pulls a number from my accounting software. Again above formula works, but as soon as I add a small if to it, it returns zero.
Here is the new formula: =IF(B14=0,0,-PL(Variables!$B$18,Variables!$B$12,B$2-7,B$2-7,"i","i","i","i","i","i"))
I want it to not pull form the accounting software if the cell 2 rows above it is zero; however, even if the cell isn't zero it still initially pulls zero. If I then click on the cell it works.
My GUESS is that the formulas all run at the same time so while the cell 2 rows above it are pulling numbers they are in fact zero the first time this formula is looking at that cell. Thoughts on a fix?
Yes automatic calc is on, and I have tried the text to columns trick. I think it has something to do with timing of the value of a cell during recalc.
I have the following formula that works just fine: -PL(Variables!$B$18,Variables!$B$12,B$2-7,B$2-7,"i","i","i","i","i","i"))
This is a custom add in that basically pulls a number from my accounting software. Again above formula works, but as soon as I add a small if to it, it returns zero.
Here is the new formula: =IF(B14=0,0,-PL(Variables!$B$18,Variables!$B$12,B$2-7,B$2-7,"i","i","i","i","i","i"))
I want it to not pull form the accounting software if the cell 2 rows above it is zero; however, even if the cell isn't zero it still initially pulls zero. If I then click on the cell it works.
My GUESS is that the formulas all run at the same time so while the cell 2 rows above it are pulling numbers they are in fact zero the first time this formula is looking at that cell. Thoughts on a fix?