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

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

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

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
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.

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
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.

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 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:

=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
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.




--
Steve (3)