C
Canon
Sorry if this is a repeat, I keep getting an error message.
Excel 2007
I am using the following formulas in cell D13;
=IF(ISNA(VLOOKUP(C13,List!$A$1:$D$306,2,FALSE)),"",VLOOKUP(C13,List!$A$1:$D$306,2,FALSE))
In cell E13; =SUM(D13*0.3645)
In cell F13; =SUM(B13*E13)
When C13 is empty, nothing shows up in D13 - good, but I would like to have
nothing show up in both E13 and F13, (right now #VALUE shows up), when C13 is
empty. At the end the colum must total for this I am using;
=SUMIF(F13:F38,"<1E100")
Excel 2007
I am using the following formulas in cell D13;
=IF(ISNA(VLOOKUP(C13,List!$A$1:$D$306,2,FALSE)),"",VLOOKUP(C13,List!$A$1:$D$306,2,FALSE))
In cell E13; =SUM(D13*0.3645)
In cell F13; =SUM(B13*E13)
When C13 is empty, nothing shows up in D13 - good, but I would like to have
nothing show up in both E13 and F13, (right now #VALUE shows up), when C13 is
empty. At the end the colum must total for this I am using;
=SUMIF(F13:F38,"<1E100")