format cells in degrees & minutes of arc.
Have you looked at what MOD does? [If not, please take the trouble to look
it up in Excel help, and/or just try it.]
In what way does it not do what you want?
--
David Biddulph
dougsan wrote:
"Jarek Kujawa" wrote:
try:
=MOD(A1,360)
HIH
On 20 Lut, 11:58, dougsan wrote:
I am back!!!!!
What i am trying to do is format cells in degrees & minutes of arc.
i have tried useing the time function but the problem i run into is
if i have 270° and i need to add 100° in a clockwise direction i
get 370° not 10°
HI i think this is on the right track. but lets go one stage futher.
if the sum of the numbers are more than 360 then take 360 off but if
the sum is less than 360 leave it stand
|