#DIV/0! error

sharky12345

Well-known Member
Joined
Aug 5, 2010
Messages
3,317
Office Version
  1. 2016
Platform
  1. Windows
I'm getting #DIV/0 using this;

=IF(A8="","",$H8/$C8)

But I can't seem to work out how to use the ISERROR part if it can be used at all to hide the error itself - anyone?

What solution there is must take into account the fact that I am also wanting to show nothing if A8 is empty.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,326
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
=iferror(if(a8="","",$h8/$c8),"")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,528
Messages
5,548,578
Members
410,853
Latest member
Tramp71
Top