lundi 26 octobre 2020

Excel, how to make a for loop?

I have this code here:

=C5
-(IF(G9="C",(IF(G10=0,$C2,$C2-G10)),))
-(IF(H9="C",(IF(H10=0,$C2,$C2-H10)),))
-(IF(I9="C",(IF(I10=0,$C2,$C2-I10)),))

etc...

It continuates from G9 to J9.

Is there a way to make it with less code? In java I would have used a for loop, but I don't know how to do it with Excel

Thanks!!

Aucun commentaire:

Enregistrer un commentaire