Replace error signs

[ianripping]

When i get errors on my workheets i get that dreaded DIV#0! thing. Is
there anyway that it can be replaces with some other text like Unknown
or N/A. Maybe using the IF command?

 

[John Wilson]

ianripping,

There are a number of ways to do this.
One easy one is to check if the divisor is zero before
trying to do any math with it.

e.g.
Say you have a formula like this:
=A1/B1
If B1 = 0 then you'll get the DIV/0 error.
=IF(B1=0,"",A1/B1)
will return a blank if B1 is zero.
or.....
=IF(B1=0,"N/A",A1/B1)
will return N/A if B1 = 0

John

 

[ianripping]

Thanks. That is great

 

[John Wilson]

You're welcome

Thanks. That is great

creating financial statements