K
klappin
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,FORMULAS!$T$3:$BF$11,9,FALSE)*U15))))))
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,FORMULAS!$T$3:$BF$11,9,FALSE)*U15))))))