Forum Discussion
#VALUE!
I can share in your blessing, but in my case three years ahead of you and still a few months away==I'll turn 80 in October. I also share some of your experience as well--it wasn't my main career, but I did become something of a power user with Excel and its predecessors in the spreadsheet world (Lotus, Quattro), as well as learning SQL to write extensive queries from a mainframe database--and therefore can fully appreciate how frustrating it can be when, with all that experience, you can't put your finger on what's causing the #VALUE.
Unfortunately, an image isn't something that any of us can actually do much diagnostic work with.
Looking at the formula in the formula bar in the image, and the cell from which it appears to come (I748), I can tell:
- the formula IS working in I748
- and it's not in any of the subsequent rows--well, more precisely, it's working to deliver #VALUE
Which suggest something I'm sure you're well aware of, that the issue is most likely in whatever is in cells G749 and H749...and once introduced it doesn't self-correct since it's always in I749, I750, I751,... and on. Has the formula been changed in any way in any of the rows? I will offer the observation that the formula that's visible in this image is NOT the formula you included in your original post.
What happens if you place fresh numeric values in some of the cells in columns G, H and I down below where the #VALUE first appears? Down in the 760s?
And since you made this image from a modified copy of the spreadsheet itself, is it now possible to post that actual--but modified and therefore not revealing sensitive personal data--spreadsheet?
This SS & formula has been working fine for 2 years with empty fields, but I have been doing quite a bit of moving things around in this SS when it started giving the #Value!.
What exactly is that about?
thanks for your help
Janice (also retired and long time computer user, not a programmer like you guys but worked closely with lots of them)
Pennyloafer wrote: I had to insert zeros in the cells that were empty.
This SS & formula has been working fine for 2 years with empty fields, but I have been doing quite a bit of moving things around in this SS when it started giving the #Value!.
What exactly is that about?
I'm not sure what exactly your "exactly" is about: is it the appearance of #VALUE!?
And in the absence of the spreadsheet to examine, one can only speculate. My speculation is that those "empty fields" aren't really empty; they just appear empty, perhaps with spaces, perhaps with other special (but also invisible to the human eye) characters.
In any event, it's good to read that you got it working. And I'm so sorry to hear about the flooding and the temporary housing you had to endure. That's got to be very disorienting.