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