The CHAR function returns the relevant character from the ASCII code. The syntax of the function …
Lesson#36: Convert ASCII code to its relevant character with the function CHAR Read more →
DEC2OCT converts the Decimal number system to the Octal number system. Syntax of this function is DEC2OCT( …
DEC2HEX converts the Decimal number system to the Hexadecimal number system. Syntax of this function is DEC2HEX( …
Lesson#34: Decimal to Hexadecimal by DEC2HEX function Read more →
DEC2BIN converts the Decimal number system to the Binary number system. The syntax is DEC2BIN(Number, [places]) …
Lesson#33: Decimal to Binary by DEC2BIN function Read more →
The UPPER function converts a text string to all uppercase letters. The syntax of this function is …
Lesson#32: UPPER, LOWER, PROPER, TRIM Text functions in Excel Read more →
This post is a continuation of one of my previous posts Lesson#27: How to make a …
Lesson#31: Current dynamic calendar for whole Year Read more →
What is NETWORKDAYS function? This function calculates the networking days between two dates. This function is …
Lesson#28: NETWORKDAYS and NETWORKDAYS.INTL is very essential for project scheduling Read more →
WEEKDAY is a function that returns the day of the week corresponding to a date. from …
Lesson 25 is a discussion about the function WEEKNUM. This function returns the week number in …
Lesson#25: Function WEEKNUM has a good use for construction people Read more →
In this post, we will discuss two formula which converts the Roman number system to Arabic …