what IF - formula question

[Rasoul Khoshravan]

=IF(G43=0,"",sum(hH43/G32)).
This will avoid division by zero so #DIV/0 will not appear.
Also if you want to drag the formula, I think you should use fixed reference
($G$32) instead of relative reference (G43).

 

[Guest]

What IF formula question. My cell has a formula in it =sum(H43/G43). I
want this cell blank ҠIf the result is not a percentage (the cell has been
formatted to be a %). When I drag the formula to many other cells some of
them are #DIV/O! and I want those cells to be blank.

I can’t figure out how to do this. Thanks for your time and help!

 

[Guest]

Sorry for the multiple posts. Twice a window opened when I clicked post and
said there was an error and it did not post. again sorry.

 

[Bernard Liengme]

But the SUM function is not needed
=IF(G43=0,"",H43/G32).

 

[Guest]

except I need the G43=0 to include + & - results. I only need #div/0! to be
shown as nothing.