F1 Streams is a free live streaming service for Formula 1 fans. Watch Formula 1 races, qualifying and practice sessions only on F1 Streams Reddit.
1. Use absolute cell references: Instead ofB5, use$B$5in your formula. The dollar signs make the cell reference absolute, meaning it won't change when the formula is copied or dragged down. This will prevent the chain reaction and only update the current cell based on the value in A6....