writer
2,661
edits
Changes
Manuals/calci/BIN2DEC (view source)
Revision as of 02:12, 18 November 2013
, 02:12, 18 November 2013no edit summary
*If the number is not a valid number, 'Calci' returns an #ERROR message.
*If the number is not a valid number, 'Calci' returns an #ERROR message.
Below are few examples that show the use of combination of functions and get the result in decimal -
Below are few examples that show the use of combination of functions and get the result in decimal -
1)SUM(BIN2DEC(100) + BIN2DEC(101)) that displays the result as ''9''.
1)SUM(BIN2DEC(100) + BIN2DEC(101)) ''returns 9'' as a result.
2)AVERAGE(BIN2DEC(100) + BIN2DEC(101))that displays the result as ''4.5''.
2)AVERAGE(BIN2DEC(100) + BIN2DEC(101)) ''returns 4.5'' as a result.
3)BIN2DEC(110)+BIN2DEC(101)-BIN2DEC(100) that displays the result as ''7''.
3)BIN2DEC(110)+BIN2DEC(101)-BIN2DEC(100) ''returns 7'' as a result.
== Examples ==
== Examples ==