Dream wrote:
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


A basic approach in Excel 2003 might look like

=IF(ISERROR(YourFormula),"",YourFormula)

There might be better ways, depending on your version and situation.