trimmed mean function and if bold function

[Kyle]

Does anyone know if either a trimmed mean function (one
that rejects data that is more than 2 standard devations
from the mean, but does not necessarily remove a given
percent from each tail) or a if bold function (where
Excel can insert a true/false type answer (but instead
either inserting the number or inserting a blank cell
into the column is the row reference is either bold &
italliced or normal)exist? And if so how does one
find/use/implement them? Thanks for you help and time!

 

[J.E. McGimpsey]

One way for the trimmed mean (array entered: CTRL-SHIFT-ENTER or
CMD-RETURN):

=AVERAGE(IF((ABS(rng-AVERAGE(rng)))>(2*STDEV(rng)), "", rng))

where rng is your data range.

I can't follow your "if bold" function specification.

 

[Dan E]

Kyle,

I don't think an isbold function exists. Their aren't any
is(insert_desired_format_here) functions. You would
probably need to write a user defined function (VBA)

Dan E