Thread: #Value! Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Spz Spz is offline
external usenet poster
 
Posts: 4
Default #Value! Error

When I pull down a formula over many cells I get this #value! error. I
want the cell to be balnk.

Ive tried =if(k11="","",
which works in the adjectent column but not this one.

I've also tried a dozen or so conditional formatting
scenarios--nothing works.

any suggestions?

Thanks to all