Use Excel functions in AutoCAD fields

Note: This feature is just for AutoField for AutoCAD 2007 or higher.

Exponentiation

X raised to the power of Y = X ^ Y

Logarithm

The LOG function return the base-10 logarithm.

LOG(1000) = 3

Rounds a number to a specified number of digits in AutoCAD field

ROUND(number,num_digits)

Remarks

Examples:

Rounds a number up in AutoCAD field

ROUNDUP(number,num_digits)

Remarks

Examples:

Rounds a number down in AutoCAD field

ROUNDDOWN(number,num_digits)

Remarks

Examples:

Conditional statements in AutoCADfield

Conditional statement uses this structure:

IF (<condition>, <result-if-true>, <result-if-false>)

Supported Conditional Operators

Examples:

Returns the first character or characters in a text string in AutoCAD field

LEFT(text,num_chars)

Remarks

Examples:

Returns the last character or characters in a text string in AutoCAD field

RIGHT(text,num_chars)

Remarks

Examples:

Returns a specific number of characters from a text string in AutoCAD field

MID(text,start_num,num_chars)

Remarks

Examples:

Substitutes new_text for old_text in a text string in AutoCAD field

SUBSTITUTE(text,old_text,new_text)

Examples:

Close Window