Formulas and Functions
ഈ കൺട്രോളിൽ മാറ്റം വരുത്തുന്നത് ഈ പേജ് ഒട്ടോമാറ്റിക്കായി അപ്ഡേറ്റ് ചെയ്യാനിടയാക്കും

BASETONUM

The BASETONUM function converts a number of the specified base into a number in base 10.

BASETONUM(convert-string, base)

convert-string: The string value representing the number to be converted. convert-string must contain only numbers and letters that apply in the base of the number being converted.

base: number value representing the current base of the number to be converted. base must be in the range 1 to 36.

Notes

  • This function returns a number value and can properly be used in a formula containing other number values. Some other spreadsheet apps return a string value.

Examples

=BASETONUM("3F", 16) returns 63, the decimal (base 10) equivalent of the hexadecimal (base 16) value 3F. The quotation marks are required whenever a letter is included in convert-string.

=BASETONUM(1000100, 2) or =BASETONUM("1000100",2) returns 68.

=BASETONUM(-1000100, 2) returns an error, as the minus sign is not a valid part of convert-string.

=-BASETONUM(1000100, 2) returns -68.

=BASETONUM(7279, 8) returns an error, because the digit "9" is not valid in base 8.

See alsoBIN2DECHEX2DECNUMTOBASEOCT2DEC
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
സഹായകമായോ?
കാരക്റ്റർ പരിധി: 250
പരമാവധി കാരക്റ്റർ പരിധി 250 ആണ്.
നിങ്ങളുടെ ഫീഡ്ബാക്കിന് നന്ദി.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.