按下面的逻辑写公式即可：=IF(OR(实际="",实际="-"),IF(TODAY()>要求,"C","D"),IF(实际
EXCEL里的IF公式四种条件怎么写？
按下面的逻辑写公式即可：
=IF(OR(实际="",实际="-"),IF(TODAY()>要求,"C","D"),IF(实际<=要求,"A","B"))2023-05-31
所需公式为E2=IF(OR(D2="",D2="-"),IF(C2<TODAY(),"C","D"),IF(D2<=C2,"A","B"))
2023-05-31
不知道为何你喜欢那么绕圈啊，总是把简单的事情复杂做！其实，只要举例说明，就很简单了啊
如图，只需在F4单元格输入公式：
=IF(LEN(B4)<4,"",IF(D4<>"",IF(D4<C4,"提前完成",IF(D4>C4,"超期完成","按期完成")),IF(C4>TODAY(),"进行中……",IF(LEN(E4)<2,"超期未报原因","超期："&E4))))
复制并下拉填充，即可…………
2023-06-01
