software

i need to make this work =sum(c4*d4), but i have some cells that does not
contain anything and the result looks like that #VALUE!

1 c d e(sum)
2
3 3 5 15
4 2 #VALUE!I don't want anything to apear in e4, or in the worst case i want 0 to apear
in this cell.
Anyone can help me? Thanks

Try this,

=IF(D4=quot;quot;,quot;quot;,C4*D4)

HTH
Regards,
Howard

quot;puiuluipuiquot; gt; wrote in message
...
gt;i need to make this work =sum(c4*d4), but i have some cells that does not
gt; contain anything and the result looks like that #VALUE!
gt;
gt; 1 c d e(sum)
gt; 2
gt; 3 3 5 15
gt; 4 2 #VALUE!
gt;
gt;
gt; I don't want anything to apear in e4, or in the worst case i want 0 to
gt; apear
gt; in this cell.
gt; Anyone can help me? Thanks
I'm not sure where the SUMIF come in, but from what you posted, try something
like this:

For values in C1 and D1
E1: =C1*D1

Or to NOT display zero values
E1: =IF(COUNT(C11)=2,C1*D1,quot;quot;)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;puiuluipuiquot; wrote:

gt; i need to make this work =sum(c4*d4), but i have some cells that does not
gt; contain anything and the result looks like that #VALUE!
gt;
gt; 1 c d e(sum)
gt; 2
gt; 3 3 5 15
gt; 4 2 #VALUE!
gt;
gt;
gt; I don't want anything to apear in e4, or in the worst case i want 0 to apear
gt; in this cell.
gt; Anyone can help me? Thanks

Thanks! works great...Thanks again!

quot;Ron Coderrequot; wrote:

gt; I'm not sure where the SUMIF come in, but from what you posted, try something
gt; like this:
gt;
gt; For values in C1 and D1
gt; E1: =C1*D1
gt;
gt; Or to NOT display zero values
gt; E1: =IF(COUNT(C11)=2,C1*D1,quot;quot;)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;puiuluipuiquot; wrote:
gt;
gt; gt; i need to make this work =sum(c4*d4), but i have some cells that does not
gt; gt; contain anything and the result looks like that #VALUE!
gt; gt;
gt; gt; 1 c d e(sum)
gt; gt; 2
gt; gt; 3 3 5 15
gt; gt; 4 2 #VALUE!
gt; gt;
gt; gt;
gt; gt; I don't want anything to apear in e4, or in the worst case i want 0 to apear
gt; gt; in this cell.
gt; gt; Anyone can help me? Thanks

Thank you! it really works! Thanks

quot;L. Howard Kittlequot; wrote:

gt; Try this,
gt;
gt; =IF(D4=quot;quot;,quot;quot;,C4*D4)
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;puiuluipuiquot; gt; wrote in message
gt; ...
gt; gt;i need to make this work =sum(c4*d4), but i have some cells that does not
gt; gt; contain anything and the result looks like that #VALUE!
gt; gt;
gt; gt; 1 c d e(sum)
gt; gt; 2
gt; gt; 3 3 5 15
gt; gt; 4 2 #VALUE!
gt; gt;
gt; gt;
gt; gt; I don't want anything to apear in e4, or in the worst case i want 0 to
gt; gt; apear
gt; gt; in this cell.
gt; gt; Anyone can help me? Thanks
gt;
gt;
gt;

I have one more problem...I use this vlookup formula in B cells
=IF(A2lt;gt;quot;quot;,VLOOKUP($A2,$J$1:K51,2,FALSE),quot;quot;) to extract some prices...

A B
1 01254 #N/A
2 total i.s. 12 3.65
3 total i.s. 15 2.86
4 02458 #N/A

I don't want to see #N/A ....I don't want anything to apear in B1, B4....
How can i do this??

Thanks again! My best regards
puiuluipui

quot;puiuluipuiquot; wrote:

gt; Thanks! works great...Thanks again!
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; I'm not sure where the SUMIF come in, but from what you posted, try something
gt; gt; like this:
gt; gt;
gt; gt; For values in C1 and D1
gt; gt; E1: =C1*D1
gt; gt;
gt; gt; Or to NOT display zero values
gt; gt; E1: =IF(COUNT(C11)=2,C1*D1,quot;quot;)
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;puiuluipuiquot; wrote:
gt; gt;
gt; gt; gt; i need to make this work =sum(c4*d4), but i have some cells that does not
gt; gt; gt; contain anything and the result looks like that #VALUE!
gt; gt; gt;
gt; gt; gt; 1 c d e(sum)
gt; gt; gt; 2
gt; gt; gt; 3 3 5 15
gt; gt; gt; 4 2 #VALUE!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; I don't want anything to apear in e4, or in the worst case i want 0 to apear
gt; gt; gt; in this cell.
gt; gt; gt; Anyone can help me? Thanks

The #NA means the value you are trying to lookup is not found in the
table you search in.
That could have two reasons:

1. it's not there, what do you then want to do about this?
2. you are looking in the wrong range because the K51 in your formula
is expanding the range down as you copy the formula down (or right if
you copy to the right)

Is your formula above taken from B1?
Do you really have quot;total i.s. 12quot; as a search criterion in your
pricing table?

To intercept the #NA message change your formula to:

=IF(A2lt;gt;quot;quot;,If(ISNA(VLOOKUP($A2,$J$1:K51,2,FALSE)), 0,VLOOKUP($A2,$J$1:K51,2,FALSE)),quot;quot;)Hans