turn #value into blank cell
Just make note that ISERROR will hide all errors including #N/A which may be
returned from a VLOOKUP
Gord Dibben MS Excel MVP
On Wed, 27 May 2009 10:45:46 -0700, amik
wrote:
I got it working....
Thanks for the help everyone
"Tanya" wrote:
IFERROR is in Excel 2007 only
try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)
On May 27, 12:53 pm, amik wrote:
for some reason it is still giving me an # name statement...
"Eduardo" wrote:
OPPss, there was an extra space
=iferror((A5/B5)-1,"")
"amik" wrote:
That gives me a #name....
"Eduardo" wrote:
Hi, use
=iferror( (A5/B5)-1,"")
"amik" wrote:
My formula is (A5/B5)-1
is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?- Hide quoted text -
- Show quoted text -
|