formula becomes text

  • Thread starter Thread starter kang
  • Start date Start date
K

kang

there is a formula
=IF(ISERROR(VLOOKUP(A3691,A$1:A3690,1,FALSE)),"") &
IF(ISERROR(VLOOKUP(A3691,A3692:A$6867,1,FALSE)),"")

when I change A$6867 to A6967
the formula becomes text
I mean what I see is formula itself not the result
thanks.
 
Sounds like the cell is formatted as TEXT.

Select the cell in question.
Change the format to GENERAL then hit function key F2 then hit ENTER.
 
Back
Top