Excel表格使用IF条件判断
=IF(M255="","尚未结清",IF(M255<=L255,"按期结清","逾期"&M255-L255&"天"))
=IF(M255="","尚未结清",IF(M255<=L255,"按期结清","逾期"&M255-L255&"天"))
=IF(是否,是,IF(是否,是,否))
字符串拼接 =条件1&条件2 表格显示 条件1条件2
=IF(M255="","尚未结清",IF(M255<=L255,"按期结清","逾期"&M255-L255&"天"))
=IF(M255="","尚未结清",IF(M255<=L255,"按期结清","逾期"&M255-L255&"天"))
=IF(是否,是,IF(是否,是,否))
字符串拼接 =条件1&条件2 表格显示 条件1条件2