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