Function can not read cell value properly without enter

[ksgoodwin]

I am using an "if" function to compare two cells and the result is a
value from a third cell if true and nothing if false. No problems
with this function till I copy and paste special a value into the B7
cell.

=IF($B7=$L$5,$E7,)

It computes the result if the value in B7 is an alphanumeric value
(example "T5") but not if the value is numeric (example "5"). To get
the numeric value to work, I must click on the B7 cell and press
enter. I use an function in the cell I copy the values from; reason
for using paste special. Thoughts?

Ken

 

[RagDyeR]

The formula whose values you're copying into B7 is probably *not* a true XL
number.

A formula, something like this, would duplicate the problem you're having:

=If(A1>0,"25",B1)

Where the 25 is not truly a numeric value.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I am using an "if" function to compare two cells and the result is a
value from a third cell if true and nothing if false. No problems
with this function till I copy and paste special a value into the B7
cell.

=IF($B7=$L$5,$E7,)

It computes the result if the value in B7 is an alphanumeric value
(example "T5") but not if the value is numeric (example "5"). To get
the numeric value to work, I must click on the B7 cell and press
enter. I use an function in the cell I copy the values from; reason
for using paste special. Thoughts?

Ken

 

[daddylonglegs]

Try changing to

=IF($B7&""=$L$5&"",$E7,)