Can someone review the following formula and tell me why I am getting the
#Value error?

=IF(Spacg8,(FULL/VLOOKUP(TYPE,ProductData,6,FALSE)/((Spacg/8)))+(BBGROUT+BEAM*EA*QTY)+(((IF(ISBLANK(LINTEL),H ALF*Setup!$C$15,HALF*Setup!$C$17))+(Setup!$C$19*CO RNERS/2))/VLOOKUP(TYPE,ProductData,6,FALSE)),BBGROUT),IF(Spa cg<16,(LENGTH*HEIGHT*QTY*EA*1.125)/VLOOKUP(TYPE,ProductData,6,FALSE))

The problem seems to be in the 2nd part of the formula from
IF(Spacg<16,(LENGTH*HEIGHT*QTY*EA*1.125)/VLOOKUP(TYPE,ProductData,6,FALSE)).
The spacg8 represents numbers 16, 24, 32, 48, etc so if the spacg is 16, 24,
32, etc I want it to perform the 1st part of the function. If the spacg is 8,
I want it to perform the 2nd part of the function. I hope this isn't
confusing.

Thanks in advance

Ed