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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,113,936
Messages
5,545,104
Members
410,656
Latest member
Hydraulics
Top