Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to remove #REF and #N/A
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to remove #REF and #N/A
#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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to remove #REF and #N/A
Go through the below link for details.
http://www.contextures.com/xlFunctions02.html -------------------- (MS-Exl-Learner) -------------------- "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to remove #REF and #N/A
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to remove #REF and #N/A
Not clear what you mean by "dragging a formula" and what you eventually want
to achieve. Delete cells containing errors? 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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove an excel link that break link won't remove | Excel Worksheet Functions | |||
remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
Remove ÿ | Excel Discussion (Misc queries) | |||
remove an add in from xla | Excel Discussion (Misc queries) |