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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,871
Members
409,842
Latest member
mfernandezcean
Top