IF statement problem

[adowning]

I am trying to use the IF statement in conjunction with the AVG statement to
filter some data through a standard deviation table with no success.

Where I get lost is, I want to ignore data that falls outside the standard
deviation value.

Here is the formula I'm trying to use, please help if you can -
=AVERAGE((A3,A34,A65,A96,A127,A158,A189,A220,A251,A282,)=if A3>A381, then 0))

 

[Pecoflyer]

I am trying to use the IF statement in conjunction with the AV
statement to
filter some data through a standard deviation table with no success.

Where I get lost is, I want to ignore data that falls outside th
standard
deviation value.

Here is the formula I'm trying to use, please help if you can -
=AVERAGE((A3,A34,A65,A96,A127,A158,A189,A220,A251,A282,)=if A3>A381
then 0))

Will this do ?
=IF(A3>A381,0,AVERAGE(A3,A34,A65,A96,A127,A158,A189,A220,A251, A282,)

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Roady [MVP]]

Wrong newsgroup?

 

[Roady [MVP]]

*Adding your XL version* to your post helps finding solution faster
Posting it in an Excel newsgroup will probably help even more :-D



-----