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?