如题,如图,在这份Excel表格中,如果把D1单元格内的函数公式下拉至D5,则函数公式中的"B1"会相应地在第2、3、4、5行变为"B2"、"B3"、"B4"、"B5"。请问有什么方法可以保证此处的"B1"在下拉时不会改变呢?D1单元格内的函数公式:=IF(A1<B1,IF(C1="READY","",IF(C1="COMPLETED","","RTS DATE PASSED")),"")。
=IF(A1<B$1,IF(C1="READY","",IF(C1="COMPLETED","","RTS DATE PASSED")),"") 改用此公式,试一试 =IF(A1<$B$1,IF(C1="READY","",IF(C1="COMPLETED","","RTS DATE PASSED")),"")追问