" 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?

 

[Joe4]

Welcome to the Board!

It is structured incorrectly.
Can you tell us in plain English exactly what you want it to do?

 

[Jim Chad]

Welcome to the Board!

It is structured incorrectly.
Can you tell us in plain English exactly what you want it to do?

If F12 is blank go on to the 2 if statements. If f12 is not blank, I would like the contents of 712 to be copied here.

 

[Joe4]

You are missing the inner IF for your nested IF statements, i.e.

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

 

[Jim Chad]

Thank you, very much!

 

[Joe4]

You are welcome!

 

[Jim Chad]

=IF(ISBLANK(D12),IF(F17<365,F27,IF(F17>364,F37,F12)))

This is what I have now and am still getting false message

 

[Joe4]

Please let us know your values in the following cells, so we can try to recreate your scenario:
D12
F12
F17
F27
F37

 

[Jim Chad]

please let us know your values in the following cells, so we can try to recreate your scenario:
d12

7/2/2018

<tbody>
</tbody>

f12 =if(and(isblank('start here'!c6),isblank('start here'!c7),isblank('start here'!c8),isblank('start here'!c9)),"",d12)

<tbody>
</tbody>

f17
=datedif(d11,d12,"d")
f27
=if(f17<365,f22,"")
f37

=if(f17>365,f32,"")

 

[Joe4]

Sorry, since some of those cells actually reference other cells and ranges, I need to know the value being returned/shown in each of those cells.

Also, since I don't know where you are and what date format you typically use, does 7/2/2018 mean "February 7, 2018", or "July 2, 2018"?