im trying to use a formula that says IF (A1=1, B1=2) and apply is to the whole column of B, but it keeps saying that im doing a circular reference. I understand what the circular reference is but how do i do what im trying to do w/o getting one?