David --

If the width of the building in feet is in A1, then try:

=INT(A1/3)+1

unless I'm missing something from your description.

HTH

"David Bryant" wrote:

I have what to me seems like a difficult task. I am creating a workbook that
will convert the number of 3 foot panels needed on the gable end of a
building when given roof pitch, wall height, width and length. I am able to
do everything but this; on the width of the builoding it will increase the
panels in length every three feet. I want excell to calculate the # of panels
needed and at what length. If you have any Ideas please email me at
.