#DIV/0!

luisitocarrion1900

Board Regular
Joined
Oct 30, 2017
Messages
168
Office Version
  1. 365
Platform
  1. Windows
I have this formula =SUM(C7/D7) but because the data in those columns is 0 I get a #DIV/0! how can I change that to show 0%
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,216
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,194
Messages
5,546,484
Members
410,742
Latest member
WalterSil
Top