#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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

JoeMo

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

Watch MrExcel Video

Forum statistics

Threads
1,114,258
Messages
5,546,818
Members
410,759
Latest member
Bufnercash
Top