$$Excel-Macros$$ Re: Pls Help- Div by Zero error

2009-09-13 Thread N.Shivkumar
Dear Anup Is it possible to send me the file for me to help you N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Pls Help- Div by Zero error

2009-09-12 Thread Dilip Pandey
Hi Anup, It is happenning because you are dividing some thing (any number) with Zero. To avoid this, you should use ISERROR function. =If(iserror(your divison formula),"",your divison formula) For better understanding, attach your spreadsheet. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons