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@google
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 formula using VBA
> From: janetdicks...@gmail.com
> To: excel-macros@googlegroups.
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
Hi Team,
I have a challenge, how can I create a formula using VBA?!
Attached file show details, but i don't want to see *#DIV/0! *error in case
columns used in division does not have any data!!
column E - F = column G (sometimes column E - F does not have any data, so i
don't want to see 0 in c
