=LOOKUP(DAY(A1),{0,11,21,31},{"上旬","中旬","下旬","下旬"}) 这个公式在EXCELKHKH 中怎样输入阿?

来源：学生作业帮助网编辑：六六作业网时间：2024/11/16 16:17:21

=LOOKUP(DAY(A1),{0,11,21,31},{"上旬","中旬","下旬","下旬"})这个公式在EXCELKHKH中怎样输入阿?=LOOKUP(DAY(A1),{0,11,21,31}

=LOOKUP(DAY(A1),{0,11,21,31},{"上旬","中旬","下旬","下旬"}) 这个公式在EXCELKHKH 中怎样输入阿?
=LOOKUP(DAY(A1),{0,11,21,31},{"上旬","中旬","下旬","下旬"}) 这个公式在EXCELKHKH 中怎样输入阿?

=LOOKUP(DAY(A1),{0,11,21,31},{"上旬","中旬","下旬","下旬"}) 这个公式在EXCELKHKH 中怎样输入阿?
你直接复制在单元格就好了是判断A1日期是上中下旬的
a1如果是2011-6-1
你双击B1把 =LOOKUP(DAY(A1),{0,11,21,31},{"上旬","中旬","下旬","下旬"}) 复制进去包含=号