how can I perform trig. functions usings grads 400deg per circle

[Guest]

I am building a spread sheet to calculate the triangles for the setting out
stations for various sites and wish to work in grads i.e. 400degrees per
circle 100minutes per degree and 100seconds per minute. I don't have a
problem with the formulae for the lengths of the tringle sides i.e.the
distance between two stations but cannot seem to get excel to work in grads
or display results in degrees, minutes, seconds.
Is there a way around this please?
Regards
Davystuff

 

[Guest]

Hi

Have a look here:
http://www.cpearson.com/excel/latlong.htm

It may help!
Andy.

 

[Bernard Liengme]

You will need to do the conversions.
Suppose A1 has grad value (say 50) and you want tit SIN of this
Use =SIN(RADIANS(A1*0.9))

If B1 has a value and you want its ASIN in grads use =DEGREES(ASIN(B1))/0.9