too many IF AND Functions HELP

Guys,

I'm new here and need some help with a thickness calculator i'm working on. I have 4000 if and functions per line in my worksheets there has got to be a better way as the file gets way to big. I have material and based on the material a thickness comes up then you type in if the resin content is plus or minus a certain percent based on that the thickness changes this is different for different material and each material has different glass types. I need shorter code. I've posted my worksheet thanks for any help. There is only 4 - 8 layers due to size so you can only choose 4 6 or 8 thanks. Can I use vba code or anything besides what I have now. I need this to go up to 50 layers and at 8 the worksheet is getting to big.

Much Thanks,

CW