SheetFX
≡
<< Go back to all functions

OCT2DEC

The OCT2DEC function in Google Sheets converts a signed octal number to decimal format. This function is useful when you need to convert numbers from octal to decimal in your spreadsheet.

Function Syntax and Parameters

Syntax: OCT2DEC(signed_octal_number)

Parameters:

  • signed_octal_number: The signed octal number that you want to convert to decimal format.

Step-by-Step Tutorial

  1. Using OCT2DEC:
    • Example: =OCT2DEC(376)
    • Result: 254

Use Cases and Scenarios

  1. Data Conversion: Convert octal numbers to decimal format for analysis or further calculations.

Related Functions

  • BIN2DEC: Convert a binary number to decimal format.
  • BIN2HEX: Convert a binary number to hexadecimal format.
  • BIN2OCT: Convert a binary number to octal format.
  • DEC2BIN: Convert a decimal number to binary format.
  • DEC2HEX: Convert a decimal number to hexadecimal format.
  • DEC2OCT: Convert a decimal number to octal format.
  • OCT2HEX: Convert an octal number to hexadecimal format.
  • OCT2BIN: Convert an octal number to binary format.
  • HEX2BIN: Convert a hexadecimal number to binary format.
  • HEX2DEC: Convert a hexadecimal number to decimal format.
  • HEX2OCT: Convert a hexadecimal number to octal format.

Related Articles