To resolve the formula you've given us, either B29 needs to be zero, or B31and G34 need to contain the same value. A loop is not needed.