"mangesh_yadav"
wrote in message
news:mangesh_yadav.1q1rug_1117796712.4913@excelfor um-nospam.com...

=IF(ISERR(DISCOUNT),"",-G46*DISCOUNT)
and
=IF(ISERR(DISCOUNT),"",SUM(G46:G48))



Mangesh

Thanks for your help.

I have entered your formulas as shown, but i am still getting the #Value!
error when a new invoice is created

Eamon

Snip