DIV % FORMULA

[Paula]

Hi, I am trying to get a formula to work as follows

=(h5/i5)-1 but I want to learn how to combine this with the iserror formula
to equal 0 if there is an error instead of DIV. Can anyone explain how to
combine with iserror?

Many thanks
Paula

 

[RonaldoOneNil]

It is simpler than that for this example

=IF(i5=0,0,(h5/i5)-1)

 

[Roger Govier]

Hi Paula

=IFERROR((H5/I5)-1,0)

 

[Bernard Liengme]

=IF(ISERROR((H5/I5)-1),0,(H5/I5)-1)

but since the error occurs only when i5 is blank, this simpler formula will
also work
=IF(I5,(H5/I5)-1,0)
since any non-zero value for i5 will be taken as TRUE in the IF condition
best wishes

 

[Bernard Liengme]

It should be noted that IFERROR is available only in Excel 2007
best wishes

 

[Roger Govier]

My apologies all.
Eyesight getting poorer or reading what I want to read!!!!
I thought Paula had asked about IFERROR, but on re-reading I see it was
ISERROR.

 

[Bernard Liengme]

Know the feeling - do it all the time!