I have inserted round functions which should help. It hope it will work for you , but rounding can be tricky.
Can't you just insert new rows as needed? Select for example row 31 and insert required new rows. Then remember to copy down the formulas in E30 and F30 to the new inserted rows.
|