Thread: #VALUE! Error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR
 
Posts: n/a
Default #VALUE! Error

Try this:

=IF(D8="","",D8*$B$2)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"DJL" wrote in message
...
Oh, I forgot to say that D8 does have a formula in it. So that must be why I
get the error--the cell is not blank. Is there anything I can do so it does
not show on spreadsheet.

--