Arithmetic rules for formulae
Many formula contain one of the basic variables for a part or product. These are shown below:-
Product dimensions
X product width
Y product height
Z product depth
Part dimensions
X part length
Y part width
Z part thickness
Use these with the basic mathematical operations to get formula.
Basic Maths operations
+ add
- subtract
* multiply
/ divide
Formula are evaluated in the usual mathematical order that is * / + - so that the following result would apply.
10 + 30/2 = 25
Use brackets to make more complex definitions clear
(10 + 30)/2 = 20
A more complex formula.
X/2 + 25.0 + @PLINTH@/4 + Y/4
@PLINTH@ stands for a variable (usually in the variables table).
There are other maths functions to use:-
F(23-1/2) fractional inches
SQRT(X/2+12) square root
(Z-12)^2 square
INT() integer part of float
MOD() fractional part of float
ABS() absolute value (changes negative to positive)
RND() round a number
CEIL() rounds up to the next ceiling value
RND rounds a number to the nearest value of a specified number of decimal places. Enter =RND(value, decimal places)
RND(12.5, 0) equals 13
RND(12.34, 1) equals 12.3
A negative value for the number of decimal places rounds the number to e.g. the nearest 10, 100, etc. RND(123.4, -1) equals 120
CEIL rounds a number up to the next ceiling value.
Like the RND() operation, the CEIL operation has two arguments:
CEIL(<number>, <dec places>)
Examples:
CEIL(5,0) returns an answer of 5
CEIL(5.1,0) returns an answer of 6
CEIL(5.9,0) returns an answer of 6
CEIL(3.5+2.4+2.7,0) returns an answer of 9 (3.5+2.4+2.7 = 8.6)
CEIL(3.5,0)+CEIL(2.4,0)+CEIL(2.7,0) returns an answer of 10 (4+3 +3)
CEIL(5.01,0) returns an answer of 6
CEIL(5.01,1) returns an answer of 5.1
CEIL(5.01,2) returns an answer of 5.01
