Try something like this:

=If(Isna(your formula),"",your formula)


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Chrisinct" wrote in message
...
I created an invoice that takes a product and posts the price of that
product
into the invoice which is then multiplied by the quantity. This part works
absolutely fine however on the lines of the invoice where there is no data
entered the formula returns #N/A. The problem is when I go to sum the
collumn it always returns #N/A.

How can I use that formula and get it to sum for an invoice total without
resulting in #N/A?.

Thanks in advance for your help.