Ive tried =if(k11="","",

What's the rest of the formula? Explain what you're trying to do.

If you're getting a #VALUE! error you're probably attempting a math
operation on TEXT entries.


--
Biff
Microsoft Excel MVP


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