Nested IF function returning N/A for some cells

[leafs4life22]

This is the formula:
=SUM(VLOOKUP([@[Total Pts]],QBpts,2,FALSE)*IF([@GS]>12,0.2,IF(AND([@GS]>0,[@GS]<12.1),0.1,0)),[@[ESPN rnk]]*IF([@GS]>12,0.35,IF(AND([@GS]>0,[@GS]<12.1),0.375,0.4)),VLOOKUP([@[NFL rnk]],QBNFL,2,FALSE)*IF([@GS]>12,0.35,IF(AND([@GS]>0,[@GS]<12.1),0.375,0.4)),VLOOKUP([@FPA],QBFPA,2,FALSE)*IF([@GS]>12,0.1,IF(AND([@GS]>0,[@GS]<12.1),0.15,0.2)))

To make it simpler, here is the first "number" in the SUM:
VLOOKUP([@[Total Pts]],QBpts,2,FALSE)*IF([@GS]>12,0.2,IF(AND([@GS]>0,[@GS]<12.1),0.1,0))

The second part of this formula, the nested IF statements, they are essentially a weighting system based on the number of "GS" (games started). What I am finding with this formula is that, in cases where GS>12, it works out fine and returns a value no problem; but anything that isn't, anything from 0-12, is returning N/A. I have no idea what I could be doing wrong. Any suggestions?

[acerrhod]

#N/A - in the vlookup can not find the lookup value from lookup range, to alter this error result you may use IFERROR():

=IFERROR(SUM(VLOOKUP([@[Total Pts]],QBpts,2,FALSE)*IF([@GS]>12,0.2,IF(AND([@GS]>0,[@GS]<12.1),0.1,0)),[@[ESPN rnk]]*IF([@GS]>12,0.35,IF(AND([@GS]>0,[@GS]<12.1),0.375,0.4)),VLOOKUP([@[NFL rnk]],QBNFL,2,FALSE)*IF([@GS]>12,0.35,IF(AND([@GS]>0,[@GS]<12.1),0.375,0.4)),VLOOKUP([@FPA],QBFPA,2,FALSE)*IF([@GS]>12,0.1,IF(AND([@GS]>0,[@GS]<12.1),0.15,0.2))),"")

YOU CAN USE "" OR 0