Excel formula problem

**kenbear** · 04-09-2012, 10:20 AM

Hi, I want to enter a formula for multiple cells:

=C4:C12-C3:C11+E3:E11

with cells E4 to E12 where the results are. So I want each previous E cell to be part of the formula for the next E cell, and I am having trouble doing this. Can anyone help?

**rvasquez** · 04-09-2012, 10:23 AM

Hello kenbear,

Could you please attach a copy of your spreadsheet?

Thanks!

**DGagnon** · 04-09-2012, 10:23 AM

Hi, im sure we can assist with this problem, just have 2 requests for you first.

1. Could you please modify the title of your thread to be more specific to the question?
2. could you attach a sample workbook?

**kenbear** · 04-09-2012, 10:39 AM

I am not sure how to do either of those things. I am using libreoffice instead of microsoft excel. The formula has to be performed iteratively, I am just not sure how to do it. I am getting Err:523, in the boxes i try to perform the formula in. Thanks for the reply