Hi i'm pycoh! im widening my knowledge in excel 2010 formulas and macros.
please help me SHORTEN/SIMPLIFY these formulas.
1.
=C69/(IF($A$73="Marine Plywood",(VLOOKUP(A69,Guide!$A$3:$K$6,3)))+
IF($A$73="Ordinary Plywood",(VLOOKUP(A69,Guide!$A$3:$K$6,5)))+
IF($A$73="Phenolic",(VLOOKUP(A69,Guide!$A$3:$K$6,9)))+
IF($A$73="Chipboard",(VLOOKUP(A69,Guide!$A$3:$K$6,11)))+
IF($A$73="Versaboard",(VLOOKUP(A69,Guide!$A$3:$K$6,7)))+
IFERROR($A$73="MDF",IF(ISNA(VLOOKUP(A69,Guide!$A$9:$C$13,3,FALSE)),"",VLOOKUP(A69,Guide!$A$9:$C$13,3,FALSE))))
2.
=IF($A$73="Marine Plywood",6,
IF($A$73="Ordinary Plywood",6,
IF($A$73="Versaboard",6,
IF($A$73="Phenolic",6,
IF($A$73="MDF"," ",
IF($A$73="Chipboard",6))))))
=IF($A$73="Marine Plywood",IFERROR(C59*J59*(VLOOKUP(D59,Guide!$A$3:$K$6,2)),0),0)+
IF($A$73="Ordinary Plywood",IFERROR(C59*J59*(VLOOKUP(D59,Guide!$A$3:$K$6,4)),0),0)+
IF($A$73="Versaboard",IFERROR(C59*J59*(VLOOKUP(D59,Guide!$A$3:$K$6,6)),0),0)+
IF($A$73="Phenolic",IFERROR(C59*J59*(VLOOKUP(D59,Guide!$A$3:$K$6,8)),0),0)+
IF($A$73="Chipboard",IFERROR(C59*J59*(VLOOKUP(D59,Guide!$A$3:$K$6,10)),0),0)+
IF($A$73="MDF",IFERROR(C59*J59*(VLOOKUP(D59,Guide!$A$9:$B$11,2)),0),0)
Bookmarks