RE: $$Excel-Macros$$ Help with formula in vba

2013-12-07 Thread gargee singh
Hi Ravinder, thanks a lot, yes this is very helpful. exactly what i needed . :) Thanks and Regards, Gargee Singh From: ravinderexcelgr...@gmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 12

RE: $$Excel-Macros$$ Help with formula in vba

2013-12-07 Thread gargee singh
: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 12:45:01 +0530 Pfa, may be help you. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of gargee singh Sent: Saturday, December 07, 2013 11:47 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros

Re: $$Excel-Macros$$ Help: Creating formula using VBA

2010-07-29 Thread janet dickson
Hi Dave, Much appreciation every works perfect. Hug Love On Thu, Jul 29, 2010 at 7:08 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, In H4 enter: =IF(G4=0,,D4/G4) And similarly for other cells that contain a division operator Basically we are saying, if the denominator = 0 then

Re: $$Excel-Macros$$ Help: Creating formula using VBA

2010-07-29 Thread NOORAIN ANSARI
Hi, You can use below formula in H4 cell =IF(ISERROR(D10/G10),,(D10/G10)) Thanks, Noorain Ansari -- Date: Wed, 28 Jul 2010 21:08:00 +0300 Subject: $$Excel-Macros$$ Help: Creating formula using VBA From: janetdicks...@gmail.com To: excel-macros@googlegroups.com Hi