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 Dave,
Much appreciation every works perfect.
Hug & Love
On Thu, Jul 29, 2010 at 7:08 AM, Dave Bonallack
wrote:
> 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 nothing, otherwi
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 nothing, otherwise, do the
math.
Regards - Dave.
Date: Wed, 28 Jul 2010 21:08:00 +0300
Subject: $$Excel-Macros$$ Help: Creating fo
