Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |