how can I add degrees? ie 300degrees + 100 degrees = 40 degrees

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add magnetic headings. I need to enter the degrees as 3 figures. ie
045
I have found that I can do that when I add the degree sybmol to the figure.
But when I try to use the sum command, it wont add because the field
contains the symbol.
 
=SUMPRODUCT(--SUBSTITUTE(A1:A3,"x",""))

replace the x with your degree symbol

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Use custom formatting:

000°

Use this for both the values and the sums. The degree symbol is in the
formatting, not the cell.
 
Back
Top