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

in cell E8 I have this formula: =IF(ISBLANK(D8),"",D8*$B$2)
I get the #VALUE! error.
Can someone tell me why and how I can correct it.
I am just trying to say that if D8 is empty don't show anything, if
populated multiply D8 by B2.

Thank you for your help


--
Diana