That worked but now because there is no information in the cells I get a
#Value! error...How do I get rid of this?

"Joe User" wrote:

"Rebecca" wrote:
I need a formula that will take A1 x B1 but if the
number is less then 0 it will only how up as 0 and
if its more then 0 if will show up as the real number.

Try:

=max(0, A1*B1)

PS: For the future, it would be wise to choose a more distinctive subject;
e.g. "Multiply But No Less Than Zero?". By choosing such a non-descript
title, your posting might get lost as a response to other similarly-named
threads in some "news" (aka discussion group) readers.