Getting rid of #DIV/0!

jrabi

Board Regular
Joined
Aug 20, 2010
Messages
143
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! ?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,112,996
Messages
5,543,188
Members
410,584
Latest member
Bluefox68
Top