Excel Value Error
 

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

Excel Value Error
 

Try this:

=N(C7)*C8

--
Biff
Microsoft Excel MVP


"Jim Finecey" wrote in message
...
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

Excel 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

"Jim Finecey" wrote in message
...
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

Excel Value Error
 

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