Continuing Formula - try 3

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

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top