Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Is there an easy way to change the worksheet radian default to degrees so that I donīt have to use the 180/PI or PI/180 or the degrees function. The following is a formula to derive the Log Haversine of the number 30, Log((1-Cos(30*PI()/180)))/2)+10 and the following is to derive the number 30 from the Log Haversine, (Acos(1-(10^((D18-10))*2))*180/PI())/24 D18 being the cell with the log haversine. Surely there is an easier way to get a log haversine than this. Any help will be most appreciated. Scrungie. -- Scrungie ------------------------------------------------------------------------ Scrungie's Profile: http://www.excelforum.com/member.php...o&userid=16030 View this thread: http://www.excelforum.com/showthread...hreadid=466913 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change the tab order for a protected worksheet | Excel Worksheet Functions | |||
how to change default comment format in excel (2000) | Excel Discussion (Misc queries) | |||
Change the default chart colours | Charts and Charting in Excel | |||
Increase default size of worksheet | New Users to Excel | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |