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

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.
 
B

Bob Phillips

=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)
 
G

Guest

Use custom formatting:

000°

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top