嵌套的IF和ISBLANK公式 [英] Nested IF and ISBLANK formula
问题描述
我需要有关嵌套IF和ISBLANK公式的帮助.这是场景:
I need help with a nested IF and ISBLANK formula. Here is the scenario:
共有三列:A,B和C.所有三列都是日期.
There are three columns: A, B and C. All three are dates.
我想检索D列中A列的值(直接值).如果列A为空,则检索列B的值;如果列B也为空,则检索列C的值.此外,如果A列的年份为 2015/2016
,则将该单元格视为空白并检索B/C列.
I want to retrieve the value of column A in column D (direct value). if Column A is blank, retrieve Column B value, if Column B is also blank retrieve Column C value.
Addition to this if column A has year 2015/2016
consider that cell as Blank and retrieve Column B/C.
我该如何解决这种情况?
How do I tackle this scenario?
推荐答案
第一句话: = IF(ISBLANK(A1),IF(ISBLANK(B1),C1,B1),A1)
然后将其添加到2015/2016检查A中.
Then to add in the 2015/2016 check on A. This:
= IF(OR(ISBLANK(A3),AND(A3> = DATE(2015,1,1),A3< DATE(2016,12,31))),IF(ISBLANK(B3),C3,B3),A3)
这篇关于嵌套的IF和ISBLANK公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!