Forum Discussion
Issue getting formula to stick (properly), please help
Hello, I am back with another issue. Its an issue for me, but may not be for other members in this community. I am terrible with excel and hope someone can provide an answer or assistance on this. I ...
The references to cells in row 2, such as F2, are relative. This means that when you fill or copy the formula down from I13, F2 will become F3, F4, etc., which doesn't make sense.
You should make the references to row 2 absolute, so that they won't change. You do this by selecting such a reference and pressing the function key F4. This changes F2 to $F$2.
The formula in I13 then becomes
=IF(AND(G13>$F$2,G13<$G$2),"At Risk",IF(AND(G13>$G$2,G13<$H$2),"Schedule School",IF(AND(G13>$G$2,G13<$I$2),"Identify Replacement",IF(G13<$F$2,"Delinquent",IF(G13>$I$2,"Complete",0)))))
This can safely be filled/copied down.