Why does this formula not work? If I have a product named ABC, DEF, etc, I
want it to use the formula at the end
HLOOKUP(U14,FORMULAS!$T$3:$BF$11,9,FALSE)*U15, but it only uses it for
product OPQ. I think I have the parenthases in the wrong place, but I can't
figure it out.

=IF(U14<"ABC",IF(U14<"DEF",IF(U14<"GEH",IF(U14< "IJK",IF(U14<"LMN",IF(U14<"OPQ",0,HLOOKUP(U14,F ORMULAS!$T$3:$BF$11,9,FALSE)*U15))))))