Getting rid of #DIV/0!

[jrabi]

I have the following formula:

=(C$10)/$Q$10

Is there a way to show nothing in a cell if one of the referenced cells is a 0, vs showing the #DIV/0! ?

 

[VoG]

Try

=IF($Q$10=0,"",C$10/$Q$10)

 

[Andrew Poulsom]

Try:

=IF($Q$10,C$10/$Q$10,"")

 

[jrabi]

Works perfectly, thank you. Both formulas work.......