Hi,

There's something in the cell, one solution is
=If(ISNUMBER(C7),C7*C8,"")
or
=IF(ISTEXT(C7),"",C7*C8)

If you use the PRODUCT solution this formula will return something that
really doesn't make sense, the value of C8. I wouldn't recommend that, too
dangerous. But I know Peo is playing! In which case you could use the more
useful function =SUMPRODUCT(C7:C8), but don't!

But I do agree with Peo, you should clear the cell by pressing Del, not by
typing spacebar, Enter. In fact that can cause major headaches, ones that
can be difficult for users to find, and worse they may not realize they are
there and effecting formulas results.

--
Thanks,
Shane Devenshire


"Jim Finecey" wrote:

My formula is =c7*c8 works as long as c7 is not a blank. If made a blank
after being a number, then Value error occurs. How do I do properly?
Please. Example
1*100=100, blank*100=Value error.
--
Jim Finecey