Looping If Formulas for Columns

Hello,

I've created the following code but i'm stuck on creating a loop for it.

Please Login or Register  to view this content.

I need it to follow this format but loop until column AE. (The last if formula would be as below)

Please Login or Register  to view this content.

Any guidance / help please? I am new to loops.