Q:

Loop for printing a statement multiple time in excel

I'm new here and need your help, I have been assigned a project where I have to model beam calculations on an excel spreadsheet. My problem is that I can't find any command which can help me print a statement 'x' number of times.
E.g.
I ask the user for the number of spans his beam has, and depending on the input, I want this statement(s) to be displayed:  
"Enter load for span 1"
 "Enter load for span 2"
 "Enter load for span 3"  
And so on.....
Help please. 

A:

Your description is not that detailed, but I took a shot, and from what I understand you might be looking to have something like this:

Where you would put a number into B1, and then column C would print out as many statements as requested.
Here's the formula to that:
C1=IF(ROW()<=B$1,"Enter load for Span " & ROW(),"")

If this is not what you were looking for, show some effort and explain your situation more accurate ;)

