Excel Value Error

  • Thread starter Thread starter Jim Finecey
  • Start date Start date
J

Jim Finecey

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.
 
If it is a blank because you have a formula in that cell than that what is
expected

and if course if it is not a formula than it must be a space which is also
text so stop
using that, clear the cell of all contents

You could use

=PRODUCT(C7:C8)

which will ignore text but it will also not return zero if C7 is text or
empty

=IF(C7="",0,C7*C8)

will also work






--


Regards,


Peo Sjoblom
 
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.
 
Back
Top