is there a For(<variable>,<low range>,<high range>) like command?

I made a schedule planner, a few google searches and some brainstorming later and i couldnt find a solution i could make sense of for looping the huge string of if logic to to infinity, or until out process has an upset.

=IF(A20=$B$2,"SWITCH",IF(AND(A20-$B$2<$B$1/24,A20-$B$2>0),"CHARGING",IF(A20-$B$2=$B$1/24,"Switch",IF(AND(A20-$B$2>$B$1/24,A20-$B$2<($B$1+2)/24),"STEAM TO B/D",IF(AND(A20-$B$2>($B$1+2)/24,A20-$B$2<($B$1+7)/24),"WATER QUENCH",IF(AND(A20-$B$2>($B$1+7)/24,A20-$B$2<($B$1+7.5)/24),"VENTING",IF(AND(A20-$B$2>($B$1+7)/24,A20-$B$2<($B$1+9)/24),"DRAINING",IF(AND(A20-$B$2>=($B$1+9)/24,A20-$B$2<($B$1+11)/24),"CUTTING",IF(AND(A20-$B$2>($B$1+11)/24,A20-$B$2<($B$1+17)/24),"MAINTENANCE WINDOW",IF(AND(A20-$B$2>($B$1+17)/24,A20-$B$2<($B$1+18)/24),"O2 FREE & PRESSURE TEST",IF(AND(A20-$B$2>($B$1+18)/24,A20-$B$2<($B$1+21)),"LATEST VAPOR HEAT",IF(A20-$B$2=42/24,"SWITCH"))))))))))))

thats the wall-o-text formula .. if it makes any difference

i need it to repeat on multiples of $B$1

any help is appreciated!

thanks!