J
Jacob Skaria
=IF(COUNT(INT(A5),INT(B5))=2,(A5/B5)-1,"")
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
Hi
For me is working, I copy the formula agaiun
=IFERROR((A5/B5)-1,"")
For me is working, I copy the formula agaiun
=IFERROR((A5/B5)-1,"")
E
Eduardo
Hi
For me is working, I copy the formula agaiun
=IFERROR((A5/B5)-1,"")
For me is working, I copy the formula agaiun
=IFERROR((A5/B5)-1,"")
J
Jacob Skaria
Oops...
=IF(ISERROR(A5/B5),"",(A5/B5)-1)
=IF(ISERROR(A5/B5),"",(A5/B5)-1)
J
Jacob Skaria
Oops...
=IF(ISERROR(A5/B5),"",(A5/B5)-1)
=IF(ISERROR(A5/B5),"",(A5/B5)-1)
T
Tanya
IFERROR is in Excel 2007 only
try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)
try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)
T
Tanya
IFERROR is in Excel 2007 only
try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)
try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)
A
amik
I got it working....
Thanks for the help everyone
Thanks for the help everyone
A
amik
I got it working....
Thanks for the help everyone
Thanks for the help everyone
G
Gord Dibben
Just make note that ISERROR will hide all errors including #N/A which may be
returned from a VLOOKUP
Gord Dibben MS Excel MVP
returned from a VLOOKUP
Gord Dibben MS Excel MVP
G
Gord Dibben
Just make note that ISERROR will hide all errors including #N/A which may be
returned from a VLOOKUP
Gord Dibben MS Excel MVP
returned from a VLOOKUP
Gord Dibben MS Excel MVP