View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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