stopping #Value! showing

[coltheplumb]

Hi All ok I have this in cell J4 =IF(H4,H4/100*20,"")*G4what do I need to add to the formula to stop it putting #Value! In cell J4 ifCell H4 and G4 is empty.<o></o>
All help appreciated<o></o>
Colin X

 

[MartinDurham]

=iferror(if(h4,h4/100*20,"")*g4,"")

 

[mole999]

if the sum is not as expected you need to bracket it

H4/100*20

=33/100*20 = 6.6
=(33/100)*20 = 6.6
=33/(100*20) = 0.0165

 

[coltheplumb]

works a treat thanks very much X