Vba instead of nested if

[meslija]

Hello,
I'm trying to create an excel sheet, to calculate the bill of material of windows and doors. In the attachment you can see a sample of the table. My problem is, that i have to create a very long nested if, to calculate the necessary amount of wood.
I thought to arrange the table to use lookup, but i didn't succeed.
I'm opened to other suggestion,but i think i have to use vba.
Right now, the only working nested if is for windows with one opening.
I'm looking for materials, to begin to build the vba code.


For the mods: i hope i didn't open this thread, in the wrong section,if so, you can move it.

[p24leclerc]

I'm not sure VBA will help you in your task. I'd rather cut your task in smaller one and add various columns to get the amount of wood required. It would be very simple as you know what the formulas are and it could beeasy for you to look up for errors.

I would suggest you to have columns alike this:
Out Frame
Muntin (take into account the fact that it could be vertical or horizontal)
Fixed frame
Tilt-Turn opening
Etc...

Some columns can be duplicated or tripled to calculate each opening individually based on the type selected for that opening (I saw you have 3 columns "Type")
This way, each formula should be quite simple and you'll be able to add those numbers to get your amount of wood.