RE: $$Excel-Macros$$ HI --help me

2011-07-25 Thread Rajan_Verma
@googlegroups.com Subject: $$Excel-Macros$$ HI --help me Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks -- -- Some important links for excel users: 1. Follow

Re: $$Excel-Macros$$ HI --help me

2011-07-25 Thread Sant Ram
use formula =IF(iserror(ur formula),,ur formula)) On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks --

Re: $$Excel-Macros$$ HI --help me

2011-07-25 Thread NOORAIN ANSARI
Dear Vijay, Please find Error remover technique. * Errors-World* Error Type Error Remover Functions *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()* #N/A YES YES NO YES YES #ISREF NO YES YES YES YES #NULL NO YES YES YES YES #DIV/0! NO YES

Re: $$Excel-Macros$$ HI --help me

2011-07-25 Thread Cab Boose
Hi Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in one click. Magic. Charlie On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Vijay, Please find Error remover technique. * Errors-World*

Re: $$Excel-Macros$$ HI --help me

2011-07-25 Thread vijayajith VA
Hello All, Thank You very much.. On Mon, Jul 25, 2011 at 12:20 PM, Cab Boose swch...@gmail.com wrote: Hi Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in one click. Magic. Charlie On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI

$$Excel-Macros$$ HI --help me

2011-07-24 Thread vijayajith VA
Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Venkat CV
Hi Vijay, In Excel You May get errors are #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A if u want avoid this Tou may us IFERROR or IFERROR ISERROR Function *Best Regards,* *Venkat* On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, I have one

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread ashish koul
http://www.ozgrid.com/Excel/formula-errors.htm http://chandoo.org/wp/2009/04/20/excel-formula-errors/ On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV venkat1@gmail.com wrote: Hi Vijay, In Excel You May get errors are #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A if u want avoid

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Dilip Pandey
Hi Vijayajith, It depends which report having what kind of formula / function / macros you are working on. I have came across following errors so far:- 1) Excel Function errors - Can be corrected using ISError function(s) 2) VBA Macros - Can be prevented using Error handlers 3) Linking errors -

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread KAUSHIK SAVLA
It depends upon the mistakes u do. On 7/24/11, vijayajith VA vijayajith...@gmail.com wrote: Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks -- -- Some important