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

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

The formula works fine and does what I want it to do.

=IF(K12="","",IF(F12=J12,0.5*(E12*K12)))-E12

It's when I pull it down that the #value! shows up and I don't want
anything to show up. When I pull the formula down I want the cells to
be blank when the formula is not applicable to those cells.

On Tue, 4 Dec 2007 00:18:22 -0500, "T. Valko"
wrote:

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.

You're getting the #VALUE! because you are asking the formula to return
=""-E12, and (despite your assurances that the formula works fine and does
what you want it to do) I suspect that you don't want to try subtracting E12
from a text string.

Try =IF(K12="","",IF(F12=J12,0.5*(E12*K12)-E12))
--
David Biddulph

"Spz" wrote in message
...
The formula works fine and does what I want it to do.

=IF(K12="","",IF(F12=J12,0.5*(E12*K12)))-E12

It's when I pull it down that the #value! shows up and I don't want
anything to show up. When I pull the formula down I want the cells to
be blank when the formula is not applicable to those cells.

On Tue, 4 Dec 2007 00:18:22 -0500, "T. Valko"
wrote:

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.

You guys got me to thinking, and I fixed it. This formula solves the
problem. { At least for now, until I find some other bug. ;--)}

=IF(K12="","",IF(F12=J12,0.5*(E12*K12)-E12,-E12))

Thanks for all of the input. It's much appreciated.

On Tue, 4 Dec 2007 06:52:59 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

You're getting the #VALUE! because you are asking the formula to return
=""-E12, and (despite your assurances that the formula works fine and does
what you want it to do) I suspect that you don't want to try subtracting E12
from a text string.

Try =IF(K12="","",IF(F12=J12,0.5*(E12*K12)-E12))