Pasting Formula Values - Some do - Some Dont ??

[mstuf]

Hello --
I have a Wookbook that has two formulas that are working correcty. I'm now using a Macro to move those columns to another Workbook.
I've always thought that I must transfer the results of a Formula with Paste Special - Values in order to display the results instead of the Formula text. Or So I Thought.

The Column using this Formula

=IF(AA1=11,"Brand_New",IF(AA1=2,"Very_Good",IF(AA1=1,"Like_New",IF(AA1=3,"Good",IF(AA1=4,"Acceptable",IF(AA1=6,"Very_Good",IF(AA1=5,"Like_New",IF(AA1=7,"Good",))))))))

need Paste Special - Values to Display Properly in its new Location


but ...

The Column using this formula

=IF(LEN(AK1)<=11,"ISBN","UPC")

does NOT need Paste Special - Values to Display Properly in its new Location.


Can Anyone answer WHY ?


Thanks

 

[gardnertoo]

It could be that when the second column gets copied, the cell it looks at now (instead of AK1) has either the same value that AK1 had, or a value that yields the same answer.