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")

Try these:

E13:

=IF(OR(C13="",D13=""),"",D13*0.3645)

F13:

=IF(OR(C13="",D13=""),"",B13*E13)

Then you can use a simple SUM function at the bottom of the column.

--
Biff
Microsoft Excel MVP


"Canon" wrote in message
...
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")