=IF(D21-INT(D21)=0.5,D21,"")

If you truly want the numbers copied and pasted you would have to use VBA.


Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 07:39:01 -0700, HunterX
wrote:

I have been trying to come up with a formula that will read each cell in a
column and copy & paste only the cells that contain numbers with .50. I can
seem to properly configure the formula to read any whole number as long as it
contains .50 in it. I want these vnumbers pasted into a seperate column.

=IF(D21="*"+"0.50"),(D21),("")

Thank you very much for your assistance.