#Value! Error

  • Thread starter Thread starter Spz
  • Start date Start date
S

Spz

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.
 
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.
 
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))
 
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.
 
Back
Top