Hi Paula

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

--
Regards
Roger Govier

"Paula" wrote in message
...
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