| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DIV % FORMULA
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
Like this: *=IF(ISERROR(H5/I5-1),0,H5/I5-1)* Paula;263030 Wrote: 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 -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73433 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
It is simpler than that for this example
=IF(i5=0,0,(h5/i5)-1) "Paula" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
=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 V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
It should be noted that IFERROR is available only in Excel 2007
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
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. -- Regards Roger Govier "Bernard Liengme" wrote in message ... It should be noted that IFERROR is available only in Excel 2007 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DIV % FORMULA
Know the feeling - do it all the time!
-- Bernard "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... 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. -- Regards Roger Govier "Bernard Liengme" wrote in message ... It should be noted that IFERROR is available only in Excel 2007 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
