How do I get this problem?

[Lois Ann]

301.5/cos19.79=301.5/.94023=320.43 ?
--
Lois Ann

[pdberger]

Lois Ann --

Sorry, but not sure what your request is. However, this is the equation I
put in the cell:

=301.5/COS(19.79)

and I got 511.5117.

HTH

"Lois Ann" wrote:

> 301.5/cos19.79=301.5/.94023=320.43 ?
> --
> Lois Ann

[Lois Ann]

Yes, that is what I got too, and I need to come up with the correct anser of
320.43.
So there must be another solution to this problem. If you do this on a
calculator you'll see what I mean.
--
Lois Ann


"pdberger" wrote:

> Lois Ann --
>
> Sorry, but not sure what your request is. However, this is the equation I
> put in the cell:
>
> =301.5/COS(19.79)
>
> and I got 511.5117.
>
> HTH
>
> "Lois Ann" wrote:
>
> > 301.5/cos19.79=301.5/.94023=320.43 ?
> > --
> > Lois Ann

[SteveW]

Don't forget in excel =3D cos() uses radians *not* degrees

Im off to work, I'll put my brain around your numbers in the morning
(if no one else has)

Steve


On Wed, 02 Aug 2006 21:19:55 +0100, Lois Ann =

<LoisAnn@discussions.microsoft.com> wrote:

> Yes, that is what I got too, and I need to come up with the correct =

> anser of
> 320.43.
> So there must be another solution to this problem. If you do this on a=

> calculator you'll see what I mean.

[Pete_UK]

Steve has given you the answer, but in case you can't wait for him to
finish work you need to enter your formula as:

=301.5/COS(RADIANS(19.79))

19.79 are degrees, and as trigonometrical functions in Excel use
radians you have to convert these as shown.

Hope this helps.

Pete

SteveW wrote:
> Don't forget in excel = cos() uses radians *not* degrees
>
> Im off to work, I'll put my brain around your numbers in the morning
> (if no one else has)
>
> Steve
>
>
> On Wed, 02 Aug 2006 21:19:55 +0100, Lois Ann
> <LoisAnn@discussions.microsoft.com> wrote:
>
> > Yes, that is what I got too, and I need to come up with the correct
> > anser of
> > 320.43.
> > So there must be another solution to this problem. If you do this on a
> > calculator you'll see what I mean.

[SteveW]

Cheers Pete

too many bits in different threads and different posts

one minute we have a simple if.. next we are dividing by cos

Back to basics I think

Steve


On Thu, 03 Aug 2006 00:25:32 +0100, Pete_UK <pashurst@auditel.net> wrote=
:

> Steve has given you the answer, but in case you can't wait for him to
> finish work you need to enter your formula as:
>
> =3D301.5/COS(RADIANS(19.79))
>
> 19.79 are degrees, and as trigonometrical functions in Excel use
> radians you have to convert these as shown.
>
> Hope this helps.
>
> Pete
>
> SteveW wrote:
>> Don't forget in excel =3D cos() uses radians *not* degrees
>>
>> Im off to work, I'll put my brain around your numbers in the morning
>> (if no one else has)
>>
>> Steve
>>
>>
>> On Wed, 02 Aug 2006 21:19:55 +0100, Lois Ann
>> <LoisAnn@discussions.microsoft.com> wrote:
>>
>> > Yes, that is what I got too, and I need to come up with the correct=

>> > anser of
>> > 320.43.
>> > So there must be another solution to this problem. If you do this o=
n a
>> > calculator you'll see what I mean.
>



-- =

Steve (3)