# MultiStatus

Inserts an array of simulated LED status lights into the spreadsheet. The function displays the specified bits from a control value as a single LED with two color states.

## MultiStatus Inputs

Parameter | Description
Value | Specifies the control value (-2147483648 to 2147483647; Default = 0). Note: Any number outside this value range is treated as 0 but does not cause the function to return #ERR.
Start Bit | Specifies the first bit of the control value (0 to 31; Default = 0).
Number of Bits | Specifies how many bits to display (1 to 32; Default = 10). Each bit corresponds to one LED.
Reverse Order | Determines which bit represents the least- significant bit of the array.
0 = OFF (default) | Right-most bit is the least-significant bit.
1 = ON | Left-most bit is the least-significant bit.
Color 0 | Sets the LED color used to represent a zero bit. (Default = 0xFF0000 (red), Max: 0xFFFFFF)
Color 1 | Sets the LED color used to represent a one bit. (Default = 0x00FF00 (lime), Max: 0xFFFFFF)

Note:

- Named colors can be selected using the color picker control in the Property Sheet. The color can also be specified as Cell References to another cell that returns a color value as a 24-bit number.
- Given red, green, and blue values in the range 0-255, an RGB color value can be calculated using the formula (red * 65536) + (green * 256) + blue. Expressed in hexadecimal, this is in the 0xRRGGBB format. For example, the hexadecimal constant 0xFF8020 translates to: red=255, green=128, blue=32.

## MultiStatus Example

A spreadsheet is configured as follows:

- A1 = EditInt(0,255)

- A2 = MultiStatus(A1,0,8,0,0xFF0000,0x00FF00)

If you increment the EditInt control in cell A1, you can observe how the MultiStatus function displays the binary representation of the cell it references (in this case, A1):