=IF(AND(time>=20101001,time<=20101130),"范围内","范围外")
IF(AND(条件1,条件2),语句1,语句2),示例:当A1的值与B1的值都小于10时,C1显示"对",否则显示"错"C1输入公式:=IF(AND(A1<10,B1<10),"对","错")
if((条件1) && (条件2)){}else{}
if ( () and () ){}else{}