Hi all,

Can something like this be done: Cos(A1:A10)? That is calculate the value
of Cos(A1) through Cos(A10). If so, how? I keep gettting an error.

Lurch

The trick is to first select for instance B1:B10, then in the formula bar
put your formula and enter it
with ctrl + shift & enter

--

Regards,

Peo Sjoblom


"Charlie Johnson" <cj-(E-Mail Removed)> wrote in message
news:WpNub.10411$(E-Mail Removed)...
> Hi all,
>
> Can something like this be done: Cos(A1:A10)? That is calculate the value
> of Cos(A1) through Cos(A10). If so, how? I keep gettting an error.
>
> Lurch
>
>

Charlie,

In cell B1, you can simply enter
=Cos(A1)
and then copy down to B10.

Otherwise, you could select B1:B10, type =Cos(A1) and press
Ctrl-Enter.

Or, your could select B1:B10, type =Cos(A1:A10) and press
Ctrl-Shift-Enter.

If you want to use all the Cosine values in one cell, you could (for
example) sum them using
=SUM(Cos(A1:A10))
entered with Ctrl-Shift-Enter.

A better explanation of what you are doing would help us help you.

HTH,
Bernie
MS Excel MVP

"Charlie Johnson" <cj-(E-Mail Removed)> wrote in message
news:WpNub.10411$(E-Mail Removed)...
> Hi all,
>
> Can something like this be done: Cos(A1:A10)? That is calculate the
value
> of Cos(A1) through Cos(A10). If so, how? I keep gettting an error.
>
> Lurch
>
>

"Charlie Johnson" <cj-(E-Mail Removed)> wrote in message
news:WpNub.10411$(E-Mail Removed)...
> Hi all,
>
> Can something like this be done: Cos(A1:A10)? That is calculate the value
> of Cos(A1) through Cos(A10). If so, how? I keep gettting an error.
>
> Lurch

>
>
Also,

When I try to compute the cos(pi()/2) , I keep getting 6.12574E-17. Does
that mean 0? I know from computer programming that something that small is
essentially 0. Is that how Excel represents 0? If so, I would have thought
MS could have programmed that into Excel.

Lurch

It's a problem with any program that represents numbers in base 2.

This is a number very close to 0.
0.0000000000000000612574


You could wrap your formula with =round() (or one of its sibling functions) to
get as close as you wanted

=ROUND(COS(PI()/2),5)

will round to 5 decimal places.

Charlie Johnson wrote:
>
> "Charlie Johnson" <cj-(E-Mail Removed)> wrote in message
> news:WpNub.10411$(E-Mail Removed)...
> > Hi all,
> >
> > Can something like this be done: Cos(A1:A10)? That is calculate the value
> > of Cos(A1) through Cos(A10). If so, how? I keep gettting an error.
> >
> > Lurch
>
> >
> >
> Also,
>
> When I try to compute the cos(pi()/2) , I keep getting 6.12574E-17. Does
> that mean 0? I know from computer programming that something that small is
> essentially 0. Is that how Excel represents 0? If so, I would have thought
> MS could have programmed that into Excel.
>
> Lurch

--

Dave Peterson
(E-Mail Removed)