DIV % FORMULA

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
 
S

Simon Lloyd

Like said:
Hi, I am trying to get a formula to work as follow

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

Many thank
Paul
Click to expand...

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
B

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
 
B

Bernard Liengme

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

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