sample of 2 worksheets for measuring hurricane shutter
Sheet 1
a b c d
1 window width heigth span
2 1 36 48 vertical
3 2 36 48 horizontal
Sheet 2
a b c
1 window span non span
2 1 36 48
3 2 48 36

the only difference in the two examples is that the run of the fasteners is
in a vert. or horiz. position. is there an argument that will make excel
recognize that the width might be either the span or non-span of the window
depending on which direction sheet 1 column d stipulates? For example, can I
get it to state that the span of the shutter is the height if the fasteners
run vertically, or the span is the width if they run horizontally? This is
probably simple for ya'll, or I might not be providing enough info. Any help
would be greatly appreciated, if this works, ill be switching my entire
estimating forms to EXCEL from ink and paper. Thanks