DEC2HEX converts the Decimal number system to the Hexadecimal number system. Syntax of this function is DEC2HEX( number, [places] ) where number is the number in decimal format. [places] is optional, which specifies the number of characters that you want the returned hexadecimal …
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]) where Number is the decimal number and [places] is optional. The number of characters to use. If places are omitted, DEC2BIN uses the minimum …
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 UPPER(text). An example of the UPPER function is shown in the pictures above. The LOWER function converts a text string to all lowercase letters. The …
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 calendar in excel without VBA. I will show how to modify this calendar a little more and make it a current dynamic calendar for …
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 useful for project scheduling, employee benefits calculation, business days calculation, etc. Syntax of this function is NETWORKDAYS(start_date, end_date, [holidays]) Where, start_date is a date …
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 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. Syntax of the function is WEEKDAY(serial_number,[return_type]) serial_number is a sequential number …
Lesson 25 is a discussion about the function WEEKNUM. This function returns the week number in a year. Syntax of this function is WEEKNUM(serial_number,[return_type]) where serial_number is a date and [return_type] is optional. A number that determines on which day the …
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 and Arabic to Roman. Function ROMAN converts the Arabic number system to Roman. Syntax of this function is ROMAN( number, [type] ). Here the …
LEN is a function that is used for finding out the number of characters in a text string. Its syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more »
Three functions LEFT, RIGHT, and MID is very useful for extracting characters from a text string. In this post, we will discuss these three functions.LEFT is a function that returns the specified number of characters from the start of a …
Lesson#21: Extracting data with LEFT, RIGHT and MID function Read more »