Excel bug?

J

jpx

Just curious if anyone has ever seen this. I think it might just be
bug in excel. In sheet 1, cell H199 has the formula:

=F199&"/"&F199&
"&IF(B199="AAR","Regular",IF(B199="AAC","CDA",IF(B199="AAN","NEF","???")))

It results in #Value! even though all cell references appear to b
good.

If I copy this entire sheet to sheet 2 the error goes away and i
returns what I think is a correct value. Could this be some sort o
formatting issue
 
J

JE McGimpsey

It's definitely not a formatting issue (formatting doesn't affect the
value returned by a function) and, since it works on sheet 2, it's
exceedingly unlikely to be a bug.

It's far more likely that you have a #VALUE! error in one of your
referenced cells (e.g., F199 or B199) that your formula passes through.
 
J

jpx

That is the strange thing. There is no #value error in any of the cell
referenced by the formula
 
J

JE McGimpsey

That is indeed strange, since the concatenate operator and IF function
don't return #VALUE! errors on their own.
 
D

Dave Peterson

I could get a #value error if I had a Lotus Transition setting, er, set.

Try unchecking
Tools|options|Transition Tab|Transition Formula Evaluation

(if it's checked)

In fact, if you use excel, you may want to turn off all those transition
settings.
 
Top