Using a nested IF statement to simulate battery but need to compute actual values not comments

Trying to come up with a nested IF statement that works within a specified limit (battery state of charge) taking the necessary inputs over time.

[Sample Data Sheet]

My attempt to formulate for the State of charge operation is given below

= IF(AND(D5+A6-B6>=0.2*$G$1, D5+A6-B6<=0.95*$G$1), D5+A6-B6,0)

= IF(AND(D5+A6-B6<0.2*$G$1), D6= 0.2*$G$1+(D5+A6-B6).

= IF(AND(D5+A6-B6>0.95*$G$1), D6= 0.95*$G$1.

=IF(D5+A6-B6<=0.2*$G$1), 0.2*$G$1+(D5+A6-B6), IF(AND(D5+A6-B6>=0.2*$G$1, D5+A6-B6<=0.95*$G$1), D5+A6-B6,0), IF(D5+A6-B6>=0.95*$G$1), 0.95*$G$1)))

=IF(D5+A6-B6>=0.95*$G$1), 0.95*$G$1, IF(AND(D5+A6-B6>=0.2*$G$1, D5+A6-B6<=0.95*$G$1), D5+A6-B6,0), IF(D5+A6-B6<=0.2*$G$1), 0.2*$G$1+D5+A6-B6)))

I keep getting errors that my formulae is incorrect, please help for both state of charge and spare generation equations.

Thanks