DIV % FORMULA

  • Thread starter Thread starter Paula
  • Start date Start date
P

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
 
=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
 
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.
 
Back
Top