在B1中间加个$符号即可，例：B$1
=IF(A1改用此公式，试一试=IF(A1<$B$1,IF(C1="READY","",IF(C1="COMPLETED","","RTS DATE PASSED")),"")
