There are a few ways to copy and paste IF formulas while maintaining correct cell references in Excel:

Method 1: Using Relative References (Default)

This is the simplest method and works well if you want the formula to adjust based on where it's pasted.

1. Enter your IF formula in the desired cell. (e.g., `=IF(A1>10, "High", "Low")`)
2. Select the cell with the formula.
3. Copy the cell (Ctrl + C).
4. Select the destination cell(s) where you want the formula copied.
5. Paste the formula (Ctrl + V).

Explanation: By default, Excel uses relative references. This means when you copy the formula, the cell references within the formula will adjust relative to the new position. For example, if you copy the formula `=IF(A1>10, "High", "Low")` from cell B2 to C3, it will automatically change to `=IF(B2>10, "High", "Low")` because B2 is one column to the right and three rows down from A1.

Method 2: Using Absolute References

This method is useful if you want the formula to reference specific cells regardless of where it's pasted.

1. Enter your IF formula.
2. Press F4 after entering each cell reference you want to lock as absolute (e.g., `=IF($A$1>10, "High", "Low")`). Pressing F4 will add dollar signs ($) before the row and column, making them absolute references.
3. Copy the cell with the formula.
4. Select the destination cell(s).
5. Paste the formula.

Explanation: By adding dollar signs ($) before the row and column in the cell references, you create absolute references. These references will always point to the specific cell location regardless of where the formula is copied.

Method 3: Using Copy & Paste Values then Editing Formula

1. Enter your IF formula.
2. Copy the cell with the formula (Ctrl + C).
3. Select the destination cell(s).
4. Paste using Paste Values Only (often Ctrl + V then right-click and choose "Paste Values Only" or a similar option depending on your Excel version). This will paste only the result of the formula, not the formula itself.
5. Edit the pasted value and adjust the cell references manually if needed.

Note: This method is less efficient but can be useful if you only need the calculated value and don't want a dynamic formula.

Choose the method that best suits your needs depending on whether you want the cell references to adjust or remain fixed when copying the IF formula.