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

X raised to the power of Y = X ^ Y

The LOG function return the base-10 logarithm.

LOG(1000) = 3

**ROUND(number,num_digits)**

**Number**is the number you want to round.**Num_digits**specifies the number of digits to which you want to round number.

**Remarks**

- If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
- If num_digits is 0, then number is rounded to the nearest integer.
- If num_digits is less than 0, then number is rounded to the left of the decimal point.

**Examples:**

- ROUND(2.15, 1) = 2.2
- ROUND(2.149, 1) = 2.1
- ROUND(-1.475, 2) = -1.48
- ROUND(21.5, -1) = 20

**ROUNDUP(number,num_digits)**

**Number**is the number you want to round.**Num_digits**specifies the number of digits to which you want to round number.

**Remarks**

- If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
- If num_digits is 0, then number is rounded up to the nearest integer.
- If num_digits is less than 0, then number is rounded up to the left of the decimal point.

**Examples:**

- ROUNDUP(3.2,0) = 4
- ROUNDUP(76.9,0) = 77
- ROUNDUP(3.14159, 3) = 3.142
- ROUNDUP(-3.14159, 1) = -3.2
- ROUNDUP(31415.92654, -2) = 31500

**ROUNDDOWN(number,num_digits)**

**Number**is the number you want to round.**Num_digits**specifies the number of digits to which you want to round number.

**Remarks**

- If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
- If num_digits is 0, then number is rounded down to the nearest integer.
- If num_digits is less than 0, then number is rounded down to the left of the decimal point.

**Examples:**

- ROUNDUP(3.2,0) = 3
- ROUNDUP(76.9,0) = 76
- ROUNDUP(3.14159, 3) = 3.141
- ROUNDUP(-3.14159, 1) = -3.1
- ROUNDUP(31415.92654, -2) = 31400

Conditional statement uses this structure:

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

**Supported Conditional Operators**

- < Less than
- <= Less than or Equal
- > Greater than
- >= Greater than or Equal
- = Equal
- <> NOT Equal

**Examples:**

- A2 = 50
- IF(A2<=100,"Within budget","Over budget") = Within budget
- IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) = F
- IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F")))) = A

**LEFT(text,num_chars)**

**Text**is the text string that contains the characters you want to extract.**Num_chars**specifies the number of characters you want LEFT to extract.

**Remarks**

- Num_chars must be greater than or equal to zero.
- If num_chars is greater than the length of text, LEFT returns all of text.
- Num_chars cannot be omitted.

**Examples:**

- LEFT("Sale Price",1) = S

**RIGHT(text,num_chars)**

**Text**is the text string that contains the characters you want to extract.**Num_chars**specifies the number of characters you want RIGHT to extract.

**Remarks**

- Num_chars must be greater than or equal to zero.
- If num_chars is greater than the length of text, RIGHT returns all of text.
- Num_chars cannot be omitted.

**Examples:**

- RIGHT("Sale Price",1) = e

**MID(text,start_num,num_chars)**

**Text**is the text string that contains the characters you want to extract.**Start_num**is the position of the first character you want to extract in text. The first character in text has start_num 1, and so on.**Num_chars**specifies the number of characters you want MID to return from text.

**Remarks**

- If start_num should be greater than 0 and less than the length of text.
- If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, MID returns the characters up to the end of text.
- num_chars should be positive.

**Examples:**

- MID("Fluid Flow",1,5) = Fluid

**SUBSTITUTE(text,old_text,new_text)**

**Text**is the text or the reference to a cell containing text for which you want to substitute characters.**Old_text**is the text you want to replace.**New_text**is the text you want to replace old_text with.

**Examples:**

- SUBSTITUTE(A2, "Sales", "Cost") = Cost Data
- SUBSTITUTE(A4, "1", "2") = Quarter 2, 2022