C
capnmike
When I paste an "IF" function and then edit any of the result-"arguments",
the function then stops acting as a function and appears as text in the cell
it is supposed to operate in.
Example: I paste (in a cell):
=IF(VLOOKUP($E$3,'Paste-here'!$A$3:$AO$150,39)<>"","R2","")
Then change it to:
=IF(VLOOKUP($E$3,'Paste-here'!$A$3:$AO$150,39)<>"","FI2","")
(i.e: all I have changed is the TRUE result)
Result: this function then becomes text (instead of a function). Changing it
back to the original does not solve the problem. I have tried formating the
cell as General, Text, even Number, but nothing helps. It's as if Excell has
cast quote marks around the entire function, (but none show).
the function then stops acting as a function and appears as text in the cell
it is supposed to operate in.
Example: I paste (in a cell):
=IF(VLOOKUP($E$3,'Paste-here'!$A$3:$AO$150,39)<>"","R2","")
Then change it to:
=IF(VLOOKUP($E$3,'Paste-here'!$A$3:$AO$150,39)<>"","FI2","")
(i.e: all I have changed is the TRUE result)
Result: this function then becomes text (instead of a function). Changing it
back to the original does not solve the problem. I have tried formating the
cell as General, Text, even Number, but nothing helps. It's as if Excell has
cast quote marks around the entire function, (but none show).