=if(iserror(e3*d3),"",e3*d3)
or
if(or(isblank(e3),isblank(d3)),"",e3*d3)
************
Anne Troy
www.OfficeArticles.com

"Tony Canevaro"
wrote in message
news:Tony.Canevaro.1xfweb_1130213112.422@excelforu m-nospam.com...

Wow, sooo close.

I added a Qty column and then a Price column. Then I used the formula
=(E3*D3) copied down.

Works great except for the cells that have no data, I get a #Value
error. As sson as there is data in the field it all works well enough
for my purpose but how can I hide, or fix this?


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile:
http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640