Forum Discussion
Solved
Formula Help
I am writing what I feel is a bit of a complicated formula where one cell points to another, and then that one is looked at by another and so on. I am stuck with one area. I have a cell that looks at...
So, you don't have blank cell. You have cell with some text, e.g. with space. That could work
=IF( ISTEXT(A8), 15, IF( DAY(A8)<16,15,DAY(EOMONTH(A8,0))) )
It works until I blank the date in cell A8. Then it returns #VALUE!
This has been my frustration.
This has been my frustration.
That's surprising. As shown in the pdf. file it returns 15 if cell A8 is blank. Does it work when you open the attached spreadsheet?
The dates that were blank looked to be okay until I entered a date, and then blanked it later.
- I am getting the same result. It all seems to be working but as soon as I hit the spacebar on the date and tab out the cell shows #VALUE!
And that's been my headache for 3 days now.