First, watch out for this kind of thing:
=IF(L9=" ","",L9/$K$5)
But you returned "".
=IF(L9="","",L9/$K$5)
might be enough for you.

But just in case you return non-numeric entries:
=if(iserror(l9/$k$5),"",l9/$k$5)

(I'm not sure if the semicolon was a typo in your formula or a typo in the
post.)

Adam wrote:

Allright this is what I am trying to do....

I have a small, one page database that is on a sheet called "crap".
On the next page (sheet 3) I am trying to recall the information that
I have typed into the database located on sheet "crap".

Allright, On sheet 3 (column "L") this is the formula that I am using
to recall some select information from sheet "crap"...:

=IF(ISERROR(MATCH(A9,crap!$A$5:$A$152,0)),"",VLOOK UP(A9,crap!$A$5:$M$152,3,0))

(basically I type in a name in A9 and it pulls the corresponding
information and puts into that cell)

I know I know this is pretty basic stuff for most of you but it took
me a little while to figure it out...:)

The formula is working great...however, in another cell (column "M") I
have set the function (I stole the proceeding function from another
worksheet, so far much of my excel stuff has been stolen from here or
other places...I know I'm lame):

=IF(L9=" ","",L9/$K$5)

This works as long as the previous function brings up a number...if it
does not then I get the dreaded "#value". (sometimes the information
in that cell says "NA" and that is when it all hits the fan!)

I need a formula to go into column "M" that will basically leave
everything alone if the above "iserror" formula turns up "NA" (or
anything that is not a value)

I looked at possibly using something like this:
=IF(ISERROR(YourFormula),"";YourFormula)
but so far I have not been able to understand how to get it to work.

I am pretty new at this stuff so I appreciate any help you all might
have. I am also open to any websites or books that might be able to
help me along with this Excel stuff..:)

thanks,

Adam

p.s. I am sure that was not as clear as it would be from someone who
knew what the heck they were talking about, If I have left anything
important out I will be happy to add it.

--

Dave Peterson