Engineering functions in Canva Sheets
Engineering functions help you convert between number systems and perform bitwise operations. These are useful for data encoding, binary and hexadecimal conversions, and other technical calculations.
FUNCTION | WHAT IT DOES | EXAMPLE |
ARABIC | Converts a Roman numeral to Arabic. | =ARABIC(text) |
BASE | Converts a number to text in a given base. | =BASE(number, radix, [min_length]) |
BIN2DEC | Converts binary to decimal. | =BIN2DEC(number) |
BIN2HEX | Converts binary to hexadecimal. | =BIN2HEX(number, [places]) |
BIN2OCT | Converts binary to octal. | =BIN2OCT(number, [places]) |
BITAND | Returns the bitwise AND of two numbers. | =BITAND(number1, number2) |
BITLSHIFT | Shifts bits left by a specified amount. | =BITLSHIFT(number, shift_amount) |
BITOR | Returns bitwise OR of two numbers | =BITOR(number1, number2) |
BITRSHIFT | Shifts bits right by specified amount | =BITRSHIFT(number, shift_amount) |
BITXOR | Returns bitwise XOR of two numbers | =BITXOR(number1, number2) |
DEC2BIN | Converts decimal to binary. | =DEC2BIN(number, [places]) |
DEC2HEX | Converts decimal to hexadecimal. | =DEC2HEX(number, [places]) |
DEC2OCT | Converts decimal to octal. | =DEC2OCT(number, [places]) |
DECIMAL | Converts text in a given base to decimal. | =DECIMAL(text, radix) |
HEX2BIN | Converts hexadecimal to binary. | =HEX2BIN(number, [places]) |
HEX2DEC | Converts hexadecimal to decimal. | =HEX2DEC(number) |
HEX2OCT | Converts hexadecimal to octal. | =HEX2OCT(number, [places]) |
OCT2BIN | Converts octal to binary. | =OCT2BIN(number, [places]) |
OCT2DEC | Converts octal to decimal. | =OCT2DEC(number) |
OCT2HEX | Converts octal to hexadecimal. | =OCT2HEX(number, [places]) |
ROMAN | Converts an Arabic numeral to a Roman numeral. | =ROMAN(number, [form]) |
Was this helpful?
Helpful
Unhelpful