EXCEL CARE CONTROL ICONS ALPHABETIC REFERENCE
141 74-5577–33 (US)
EN2B-0184 GE51 R0518 (Europe)
Merge (Excel Web / Excel Web II)
Function Merges multiple inputs to a combined output
Formula Result for 4 inputs: Y = X1 + X2*P1 + X3*P1*P2 + X4*P1*P2*P3.
Example:
P1 = 2, P2 = 4, P3 = 4, P4 = 3
X1 = 1, X2 = 2, X3 = 3, X4 = 1
Y = X1 + X2*P1 + X3*P1*P2 + X4*P1*P2*P3
Y = 1 + 2*2 + 3*2*4 + 1*2*4*4
Y = 1 + 4 + 24 + 32 = 61
I/O Dialog Box
Inputs Two through sixteen analog inputs.
Each input value is rounded down to an integer value and limited to the
value 0 ... parameter value–1. The product of all parameter values must not exceed
2
16
(65536). If one of the above limits is exceeded, the "error" output is set.
Outputs Two outputs where:
Y = combined output
Err = conversion error: 0 if no error occurs, 1 if an error occurs
Internal Parameter
Parameter description Two through sixteen variable parameter (P1 … P16).
P1 … P32 Merger of the inputs.
Range: unlimited, default: 2
To Next Page
Loading...
Need help?
General
