GRAVITY function

Calculates a text block's correct angle of rotation for the indicated shape rotation to prevent the text from turning upside down.

Syntax

GRAVITY(angle,limit1,limit2)
angle	The shape's angle.
limit1	Optional. Default limit is 90 degrees.
limit2	Optional. Default limit is 270 degrees.

Remarks

The GRAVITY function is usually used in the TxtAngle cell.

The value returned is 180 degrees if angle is between the angles specified by limit1 and limit2; otherwise the value returned is 0 degrees.

All of the arguments are automatically normalized between 0 and 360 degrees by the function. If an argument does not specify units, radians are assumed.

Example 1

GRAVITY(Angle)

Returns 180 degrees if Angle is between 90 and 270 degrees; otherwise, returns 0 degrees.

Example 2

GRAVITY(2)

Returns 180 degrees, because 2 radians is between 90 and 270 degrees.

Example 3

GRAVITY(100 deg., 110 deg., 290 deg.)

Returns 0 deg.

Example 4

GRAVITY(100 deg., 290 deg., 110 deg.)

Returns 0 deg.