Function and Formula Excel 2016

10.19 Upper UPPER function returns uppercase form from text argument. The syntax is: =upper(text) See pic below for UPPER function example: Pic 10.21 UPPER function example

10.20 Value VALUE function converts string that represents number to numerical value. The syntax is: =VALUE(text) See pic below for VALUE function example: Pic 10.22 VALUE function example See table below for VALUE function examples: Formula Description Result =VALUE(“$1,000”) VALUE from “$1,000” 1000 =VALUE(“16:48:00”)- Serial number that equals = 4 hour and 48 minutes, 0.2 VALUE(“12:00:00”) “16:48:00” minus “12:00:00” (0.2 = 4:48). –:::FINISH:::– ❃❃❃❃