Hi All,

I have this excel sheet that has a bunch of formulas in it. My formulas
look at cells in the previous row. If I delete a row, the cells change to
#REF! This makes sense to me. Is there a way to write the formula so that
is just looks at the prior row instead of trying to find the row that is
deleted?

Thanks
Chad

Maybe if you used R1C1 style.

"Chad" wrote:

> Hi All,
>
> I have this excel sheet that has a bunch of formulas in it. My formulas
> look at cells in the previous row. If I delete a row, the cells change to
> #REF! This makes sense to me. Is there a way to write the formula so that
> is just looks at the prior row instead of trying to find the row that is
> deleted?
>
> Thanks
> Chad
>
>
>

This formula in E5 will always point to E4:
=OFFSET(E5,-1,0)

No matter where the formula is located, this will always point to A1:
=INDIRECT("A1")



Chad wrote:
>
> Hi All,
>
> I have this excel sheet that has a bunch of formulas in it. My formulas
> look at cells in the previous row. If I delete a row, the cells change to
> #REF! This makes sense to me. Is there a way to write the formula so that
> is just looks at the prior row instead of trying to find the row that is
> deleted?
>
> Thanks
> Chad

--

Dave Peterson