yes thanks! I just thought that it would not be so hard to write a formula
that does it, but I have not managed yet (which does not say very much since
i am no excel aficionado). however i really just wanted a nice formula that
my boss (who is worse than me when it comes to excel) would find
"impressive". but it does not seem to be doable. thanks alot, i think i will
do it your way!

"JonR" skrev:

> Another solution would be to do your calculations on a different sheet (which
> you may elect to hide), if you dont' want to mess up the appearance of your
> main tab. I do this a lot, especially if the data is underlying a chart or
> something.
> --
> HTH
>
> JonR
>
>
> "Arne Hegefors" wrote:
>
> > yeah I thought about that too but that does not seem very professional when
> > my boss looks at it...thanks anyhow!
> > "JonR" skrev:
> >
> > > I'd think the easiest thing to do would be to hide column C. I'm assuming
> > > that you just don't like having it visible.
> > > --
> > > HTH
> > >
> > > JonR
> > >
> > >
> > > "Arne Hegefors" wrote:
> > >
> > > > Hello! I have a small problem. I have two columns, A and B. In these columns
> > > > there are returns for different bonds. In column C I calculate the diffence
> > > > between A and B (C1=A1-B1). In column D I want to calculate the standard
> > > > deviation of the difference dating 30 data points back. Thus, in D31 i write
> > > > =STDAV(C1:C30).
> > > >
> > > > This all works fine. However I want to skip having the C column and make the
> > > > calculations for the standard deviation of the dÃ*fference dierctly from the
> > > > values in A and B. However I have not managed to do so. Please help me out! I
> > > > know it does not sound worthwhile but having the extra column really messes
> > > > up my spreadsheet! Any help appreciated! Thanks alot!