#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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,113,939
Messages
5,545,110
Members
410,658
Latest member
kris_friis
Top