I am trying to use excel to simulate the charging and discharging of a battery. As in once the battery reaches 1, the level of charge will decrease until it reaches 0 and then begin charging again back to 1.
I have tried using multiple IFS functions that do not seem to be working as, for example:IFS(cell<=1, cell-10%, cell>0, cell+10%), the array will always continue to decrease or increase past 0 and 1 respectively and will never loop within the range.
Hypothetically you can say that it increases 10% an hour from 0-1 and decreases 10% an hour from 1-0.
Any help much appreciated thanks.
Solved by G. E. in 11 mins