Hi,
I am trying to use this formula in the image to detect outliers based on http://www.exceldashboardtemplates.c...el-line-chart/. However, Excel keeps showing me the same error over and over again. Do you have any idea of what may be causing this error?
outliers.JPG
Thank you.
Jamie
https://www.dropbox.com/s/0wix7yomh2...liers.JPG?dl=0
Sorry for the image, I uploaded it on dropbox now.
Last edited by JamieTabone; 03-19-2015 at 07:27 PM.
You might want to read the section in the forum rules about how to get your question answered quickly
Entia non sunt multiplicanda sine necessitate
I cannot understand your answer. Is there something wrong with the question because I went through the rules, but I couldn't understand what I did wrong?
Thank you.
Last edited by JamieTabone; 03-20-2015 at 04:20 AM.
This is the part I was referring to.
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
It is located in the usage sheet thank you and sorry for not uploading it in the first place.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you. However, no effect.
It worked for me
Having downloaded the file, I just clicked on cell J3, then in the formula bar as if to edit it, then pressed <enter>. It worked for me, and copied down fine, with two values showing as #N/A
Pete
I got the same result as Pete - Here:Charts.xlsx
When I press enter it keeps showing me "Your formula has an error". Thanks for the help but I do not know what I can do more
You shouldn't even need to press enter with the file I sent you - it's already all there - I don't know what more I can do either?
Hi,
I did not use your attached file because for some reason the website is not giving me access. It keeps showing me the login screen. Should I have some particular privileges to view the file or maybe because I am still new to the forum?
Sorry for the inconvenience and thanks a lot. I really appreciate.
Jamie
Well Jamie - the only difference between our formulas is that I put double quotes around the NA() so it's "NA()"
I tried that but still nothing. Thanks anyway
I've attached my version of the file. I kept the original NA() in the formula, and copied it down.
See if you can open this one.
If you are having difficulty logging on, then if you are using I.E. ensure that you have it in compatibility mode.
Hope this helps.
Pete
I put your formula back the way it was and, just like Pete's, no issue??
Try entering:Originally Posted by JamieTabone
=IF(AND(ABS(C3-C2)>$I$3; ABS(C3-C4)>$I$3); NA(); C3)
The point is: some regions use semicolon to separate parameters instead of commas.
There should be nothing wrong with NA(). In fact, that is really the point of the solution suggested by webpage that you cite.
It is possible that your Excel uses a different language. So NA() and even IF() might be different language-specific names. However, I doubt it. First, the error would be different: the formula would return a #NAME? error or the language-specific equivalent. Second, I think you would know if IF() and NA() are not recognized in your language.
I think joe has hit the nail on the head - we all missed it.
If the OP manages to open my file, he should find that those commas have changed to semicolons automatically.
Pete
Hi,
It worked fine. It seems that my list separator on the OS was space rather than comma. I changed this long time ago because I wanted to import a csv which was space separated using http://superuser.com/questions/29144...mport-in-excel. Now it works fine.
Thanks xladept, joeu2004 and Pete_UK. I really appreciate
You're welcome - glad it's solved!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks