the angle format (º ‘ ‘’) and calculation?

Jamal NUMAN · #18 04-26-2012, 06:11 AM

Quote:

Originally Posted by macropod

That's because you're actually working with a time format and times cannot be negative. However, you can use:
=ABS(C11-C9)
and combine this with a conditional format that uses the formula =C11<C9 and colours the cell accordingly.

Many thanks Paul. This is quite helpful

I’m attaching the entire table of calculation.

As the angles and distances are collected from the fields then the need to be corrected if they don’t fit the trigonometric rules.

We need to have the negative value so that we subtract this value from each angle and therefore the error is distributed and eliminated.

Is there some work around to have the angle written in minus?

Best

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculation	Lights	Excel	5	04-18-2012 04:31 AM
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Calculation within Cells	manich1	Excel	2	12-07-2011 02:59 PM
Angle Bracket Problem, STYLEREF in Header of a Protected Document	wordjunkie	Word	0	06-18-2010 04:34 AM