[Nfb-science] excel question using the "if" function

[Christine Szostak]

Hi,
  You could sort by one and then nest the other within it (e.g., by length 
and then by width). Excel, at least 2003 allows up to three nested sorts. 
You may be able to do more though I am not sure of syntax for this.

  The best help I can give for the function, is to  use if with the "and" or 
"or" bullion operator (something like =IF(AND,b2,c2,14,0)). Sorry off hand I 
do not recall the exact syntax but Google will provide 
screen-reader-friendly examples of this. Once you have this, you would just 
paste the function into a new column and then sort by the function colon.
Many thanks,
Christine



Christine M. Szostak
Graduate Student
Language Perception Laboratory
Department of Psychology, Cognitive Area
The Ohio State University
Columbus, Ohio
szostak.1 at osu.edu
----- Original Message ----- 
From: "cheryl fogle" <cfogle at unm.edu>
To: "'NFB Science and Engineering Division List'" <nfb-science at nfbnet.org>
Sent: Tuesday, September 07, 2010 3:40 AM
Subject: Re: [Nfb-science] excel question using the "if" function


> Yes, sorting by ascending and manually separating data points is an 
> option.
> Though I wanted to run a function because I have both width and thickness
> measurements and thought the program might be faster at that task.
>
> -----Original Message-----
> From: nfb-science-bounces at nfbnet.org 
> [mailto:nfb-science-bounces at nfbnet.org]
> On Behalf Of Christine Szostak
> Sent: Monday, September 06, 2010 3:09 PM
> To: NFB Science and Engineering Division List
> Subject: Re: [Nfb-science] excel question using the "if" function
>
> Hi,
>  This may be too simple for what you want, but it sounds like you could
> just sort based on the data points and if they fall lower or higher than
> your cut-off, you should be easily able to remove them.
> Many thanks,
> Christine
>
>
> Christine M. Szostak
> Graduate Student
> Language Perception Laboratory
> Department of Psychology, Cognitive Area The Ohio State University 
> Columbus,
> Ohio szostak.1 at osu.edu
> ----- Original Message -----
> From: "cheryl fogle" <cfogle at unm.edu>
> To: "'NFB Science and Engineering Division List'" <nfb-science at nfbnet.org>
> Sent: Monday, September 06, 2010 4:11 PM
> Subject: [Nfb-science] excel question using the "if" function
>
>
>> Hi list.
>>
>> Can anyone who uses excel well write me off list at
>> cfogle at unm.edu
>>   I'm having some trouble setting up function arguments in excel to
>> highlight values that are either less-than or greater-than the 95%
>> confidence interval of the mean.  I already calculated the 95% confidence
>> limits but with 360 data points, I want a way to make excel highlight
>> values
>> that are outside of the range specified by the confidence function. This
>> is
>> for several measurements and multiple samples.  So far I haven't found 
>> the
>> info in the help file but will keep looking :)
>>
>> I'm trying to get a numerical solution that will allow me to quickly spot
>> possible outliers.  My sighted colleagues are eyeballing scatter plots 
>> and
>> though I can get the university to make tactile plots, it will take at
>> least
>> a week and I'm looking for a more precise solution that will allow me to
>> order the data in a manner that makes sense to me. Thanks.
>>
>> Cheryl Fogle
>>
>> _______________________________________________
>> Nfb-science mailing list
>> Nfb-science at nfbnet.org
>> http://www.nfbnet.org/mailman/listinfo/nfb-science_nfbnet.org
>> To unsubscribe, change your list options or get your account info for
>> Nfb-science:
>>
> http://www.nfbnet.org/mailman/options/nfb-science_nfbnet.org/szostak.1%40osu
> .edu
>
>
> _______________________________________________
> Nfb-science mailing list
> Nfb-science at nfbnet.org
> http://www.nfbnet.org/mailman/listinfo/nfb-science_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> Nfb-science:
> http://www.nfbnet.org/mailman/options/nfb-science_nfbnet.org/cfogle%40unm.ed
> u
>
>
> _______________________________________________
> Nfb-science mailing list
> Nfb-science at nfbnet.org
> http://www.nfbnet.org/mailman/listinfo/nfb-science_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> Nfb-science:
> http://www.nfbnet.org/mailman/options/nfb-science_nfbnet.org/szostak.1%40osu.edu