isnt the "correct orientation shown in sheet 2 any way so you can always
calculate the "span" from the width
--
paul
remove nospam for email addy!



"Sheaky" wrote:

> 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
>
>
>
>