## Cell formulas Change when cut and past

When I cut and paste static data (data with no formula in it), the formulas in adjacent cells change - How can I keep this from happening?

ie:
formula for F4:  =IF(ISBLANK(B4),"",IF(ISBLANK(C4),"",IF(ISERR(SUM(1-(SUM(B3:B4))/(SUM(C3:C4)))),"",(SUM(1-(SUM(B3:B4))/(SUM(C3:C4)))))))
formula for F5:  =IF(ISBLANK(B5),"",IF(ISBLANK(C5),"",IF(ISERR(SUM(1-(SUM(B4:B5))/(SUM(C4:C5)))),"",(SUM(1-(SUM(B4:B5))/(SUM(C4:C5)))))))
formula for F6:  =IF(ISBLANK(B6),"",IF(ISBLANK(C6),"",IF(ISERR(SUM(1-(SUM(B5:B6))/(SUM(C5:C6)))),"",(SUM(1-(SUM(B5:B6))/(SUM(C5:C6)))))))
formula for G5:  =IF(ISBLANK(B5),"",IF(ISBLANK(C5),"",IF(ISERR(SUM(1-(SUM(B2:B5))/(SUM(C2:C5)))),"",(SUM(1-(SUM(B2:B5))/(SUM(C2:C5)))))))

When I cut and paste cells B5:C8 to B6:C9 the formulas change from row I cut across and down:

formula for F4:  =IF(ISBLANK(B4),"",IF(ISBLANK(C4),"",IF(ISERR(SUM(1-(SUM(B3:B4))/(SUM(C3:C4)))),"",(SUM(1-(SUM(B3:B4))/(SUM(C3:C4))))))) (does not change)
formula for F5:  =IF(ISBLANK(B6),"",IF(ISBLANK(C6),"",IF(ISERR(SUM(1-(SUM(B4:B6))/(SUM(C4:C6)))),"",(SUM(1-(SUM(B4:B6))/(SUM(C4:C6)))))))
formula for F6:  =IF(ISBLANK(B7),"",IF(ISBLANK(C7),"",IF(ISERR(SUM(1-(SUM(B6:B7))/(SUM(C6:C7)))),"",(SUM(1-(SUM(B6:B7))/(SUM(C6:C7)))))))
formula for G5:  =IF(ISBLANK(B6),"",IF(ISBLANK(C6),"",IF(ISERR(SUM(1-(SUM(B2:B6))/(SUM(C2:C6)))),"",(SUM(1-(SUM(B2:B6))/(SUM(C2:C6)))))))

How do I keep this from happening? This issue really messes the whole worksheet/Workbook off.

Mike

## Solutions to the Problem Cell formulas Change when cut and past

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

## Another Safe way to Fix the Problem: Cell formulas Change when cut and past:

### How to Fix Cell formulas Change when cut and past with SmartPCFixer? 2. After the scan is done, you can see the errors and problems which need to be fixed. 3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair. 