Thread: if statement returns #VALUE! if false

Hey all,

Rather than returning #VALUE! if the if statement is false, I just want to return the contents of the cell. This is what I have:

=IF(RIGHT(A8,FIND("&",A8))<>"",REPLACE(A8,FIND("&",A8),1,""),A8)

This is the contents of a cell that returns #VALUE1:

Detroit Sales Office

This works correctly:

Detroit Sales & Engineering Office

Thanks for any response