=IF(A1="","",A1)

if you use the result of the formula in a calculation don't use it like

=A1+C2

use

=SUM(A1,C2)


that will ignore text and not return value errors


--


Regards,


Peo Sjoblom



"Michelle" wrote in message
...
I am trying to copy one cell to another with a if function. And if there
is
nothing in the cell, I would like the other cell to be blank. I have
tried
using this formula, but it gives me a #value error message.

Example:

A1=name
B1=name

My Formula: if(A1=" "," ",A1)