excel用公式将1至3月显示为第一季度答:假设A列写入了EXCEL电子表格认可的日期数据,则B1单元格写入公式 =IF(A1="","","第"&IF(OR(--TEXT(A1,"m")={1,2,3}),"第一季度",IF(OR(--TEXT(A1,"m")={4,5,6}),"第二季度",IF(OR(--TEXT(A1,"m")={7,8,9}),"三","四")))&"季度","")下拉填充公式 ...
Excel表中怎么用if函数把月份是一月二月三月的设为一季度,四五六设为二...答:公式=IF(OR(RIGHT(A5,3)="年1月",RIGHT(A5,3)="年2月",RIGHT(A5,3)="年3月"),"一季度"),IF(OR(RIGHT(A5,3)="年4月",RIGHT(A5,3)="年5月",RIGHT(A5,3)="年6月"),"二季度"),IF(OR(RIGHT(A5,3)="年7月",RIGHT(A5,3)="年8月"...