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
=if(iserror(yourformula),"",yourformula)
If you have Excel 2007, you can use:
=iferror(yourformula,"")
Regards,
Fred.
"Dream" <Dr...@discussions.microsoft.com> wrote in message
news:E26B0F51-1C34-4B81...@microsoft.com...
http://www.contextures.com/xlFunctions02.html
--------------------
(MS-Exl-Learner)
--------------------
A basic approach in Excel 2003 might look like
=IF(ISERROR(YourFormula),"",YourFormula)
There might be better ways, depending on your version and situation.
Here is one way:
1) Select the range containing the errors
2) Press F5
3) Push the "Special" Button
4) Select "Formulas" and uncheck all checkboxes except "Errors"
5) Push "OK"
6) Press your Delete Key
Cheers,
Joerg
Delete cells containing error
"Dream" <Dr...@discussions.microsoft.com> wrote in message
news:E26B0F51-1C34-4B81...@microsoft.com...