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))) )
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.
And that's been my headache for 3 days now.
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))) )- Hi! Pls check my question: https://techcommunity.microsoft.com/t5/excel/please-help-me-with-formula-in-excel/m-p/3518804
CSchaeffer , you are welcome
- THAT worked! Thank you so much!
