DIV/0 and Zero Value Hide Formula Help

[nhbartos]

Hi folks,

I am using this formula in G2.

=$F2/$C2*100

...to get a percentage.

When one or both F2 and C2 are blank, I want a blank in G2.
I don't want the DIV/0, and got rid of that, but then there was a "0%" in the cell.

Is there a formula that will not show any value unless F2 and C2 have data?

 

[Joe4]

Yes. Try:

=IF(AND(F2<>0,C2<>0,F2/C2,"")

By the way, you do not need to multiply by 100. You could just Format as a Percentage.

 

[JoeMo]

Try:
=IFERROR($F2/$C2*100,"")

 

[snjpverma]

you can try this shorter version to get rid of 0% and DIV/0 error.

=IF(C2*F2,F2/C2,"")

 

[snjpverma]

Try:
=IFERROR($F2/$C2*100,"")

JoeMo, if F2 is blank this seems to give 0% which OP wants to get rid of

 

[nhbartos]

Wow...great response everyone...Thanks!

Any of you a VBA coder?
I have another request for help out there...
https://www.mrexcel.com/forum/excel-questions/997540-visual-basic-applications-code-needed.html

 

[snjpverma]

Glad to be of help nhbartos.