#REF and #N/A mean Excel thinks you have an error in your formula. The
typical way to handle them is to modify your formula to something like:

=if(iserror(yourformula),"",yourformula)

If you have Excel 2007, you can use:
=iferror(yourformula,"")

Regards,
Fred.

"Dream" wrote in message
...
Hi,

Could you please advise on how to remove the #REF and #N/A .. I am
dragging
a formual, and i get those values a lot so instead of manually deleting
them
is tehre a a way to make them blank cells....I tried the Find Replace
Ctrl+F
but it does not read #REF....

Thanks for your help