" False" error message using isblank with 2 if statements

[Jim Chad]

IF(isblank(D12),(F17<365,F27,IF(F17>364,F37,f12)))

Can anyone tell me what is wrong with my formula?

 

[Jim Chad]

Ah, I think it was because you had a typo in your original formula (which is what I was working off of).
You had it returning F12, not D12. Here was your original formula:

[COLOR=#333333]IF(isblank(D12),(F17<365,F27,IF(F17>364,F37,[/COLOR][COLOR=#ff0000]f12[/COLOR][COLOR=#333333])))[/COLOR]

So if it is really D12 we want at the end and not F12, then simply change the last value in my last formula:

=IF(ISBLANK(D12),IF(F17<365,F27,F37),[COLOR=#ff0000]D12[/COLOR])

I copied your formula and put it in.

D12 is still blank. If D12 has a value things do work correctly.
D12 is now blank again and If F17 is < or > than 365, it will not pull the dates from F27 or F37. I even took out the formula from F17 and put in numbers.

 

[Joe4]

When D12 is blank, what does this formula return?
=LEN(D12)

 

[Jim Chad]

I think it all works now. Let me try for a while.

 

[Joe4]

OK. Where I was going with the last question is that if something is in that cell (like a single space), it is NOT considered blank.
People often think a blank and a space are treated the same way, but they are not.

 

[Jim Chad]

zero 0

 

[Jim Chad]

Thank you, I think that was it. I just changed my logic and used the word pad and everything seems to be working so far.