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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,114,189
Messages
5,546,470
Members
410,742
Latest member
WalterSil
Top