Daily Battery Cycle Formulas Give Circular Reference Errors

I'm creating a list to estimate energy utilisation for a given battery size on a daily cycle of charging from solar cells. I'm looking for tips to create this without causing circular reference errors.

I have a list with 24 hrs for one typical weekday and one typical weekend per month. Available energy/drain is given in column G. The idea is that given energy or load, the battery will charge or drain, and I can track expected usage in column K. That way I can find the minimum size needed for a give load/charge profile.

The problem is that if the the stored charge at 1am is dependent on what the charge is at midnight. To reflect this I used an If statement to skip down 24 cells if the time is zero. IE for H2

Formula:

=IFERROR(IF(C3=0, I26, I2),0)

I also added a statement to force the stored energy to 0 at 5am so that I get a fresh start each day before the sun comes up.

Formula:

=IF(C3=6, 0,IFERROR(IF(C3=0, I26, I2),0))

but this means that I'm making a circular set of formulas for each day. My if statements should prevent any errors, but I still have the circular reference issue. I would also rather not have to turn on iterative calculations.

Does anyone have a suggestion of how to accomplish this?

Many thanks.