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))) )
=IF(OR(ISBLANK(A8),DAY(A8)<16),15,DAY(EOMONTH(A8,0)))You can try this formula which seems to work in my sheet.
- It works until I blank the date in cell A8. Then it returns #VALUE!
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.
