Replace error signs

  • Thread starter Thread starter ianripping
  • Start date Start date
I

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?
 
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
 
You're welcome


ianripping said:
Thanks. That is great


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top