Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another ISERROR question...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISERROR and INDEX Funcion question | Excel Worksheet Functions | |||
if(iserror()) question | Excel Worksheet Functions | |||
IF(ISNA.. or ISERROR? question.. | Excel Discussion (Misc queries) | |||
Iserror question | Excel Worksheet Functions | |||
#REF,ISERROR, File Not Found question. | Excel Discussion (Misc queries) |